| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] validating data labels versus codes 2nd 3rd value, passing by variable names 2nd 3rd 4th variable numbers of records, handling 2nd 3rd 4th variables cks 2nd 3rd cmd cnn DatabaseName declaring 2nd 3rd 4th 5th 6th 7th double-precision variables FieldLength LockfileName naming numeric variables object variables 2nd 3rd declaring 2nd objects in For Each loops 2nd setting 2nd passing by reference passing by value prm pt 2nd 3rd RecordCount Reservations application CellColor CleanupPeriods dbReservation 2nd MasterResID 2nd qdfRetrieveCurrent ReservationRange Reservations application;MasterResID ResourceCount rsRecordsToEdit 2nd SetupPeriods StartTime SourceName string variables strUpdateSQL variant variables variant variables VBA 2nd (Visual Basic for Applications) benefits of accomodating users 2nd Excel features 2nd flexibility 2nd 3rd 4th overview 2nd 3rd dot notation 2nd 3rd 4th errors User-defined type not defined historical perspective 2nd loops Do While 2nd 3rd 4th 5th 6th For Each 2nd For-Next 2nd 3rd 4th items numbers, looping with 2nd 3rd macros GetDataFromAccess 2nd macro recorder 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th recording 2nd 3rd modules creating 2nd 3rd object model 2nd 3rd 4th 5th learning names in 2nd object variables 2nd 3rd declaring 2nd objects in For Each loops 2nd setting 2nd objects adding 2nd methods properties projects defined statements Dim 2nd 3rd 4th 5th End Sub New 2nd Option Explicit 2nd Set 2nd Sub With 2nd 3rd 4th 5th 6th 7th subroutines creating 2nd variables declaring 2nd 3rd 4th 5th 6th naming numeric variables string variables variant variables VBE (Visual Basic Editor) Properties window starting VBE (Visual Basic Editor) Properties window starting verifying user requests 2nd View menu commands Relationships viewing relationships 2nd Visible property (worksheets) 2nd Visual Basic Editor opening Visual Basic Editor (VBE) Visual Basic Editor. [See VBE] Visual Basic for Applications. [See VBA] VLOOKUP function 2nd 3rd 4th 5th calculating commissions with 2nd 3rd column numbers lookup arrays lookup types lookup values two-column ranges 2nd 3rd |