| [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] labels labels versus codes 2nd data validation 2nd 3rd lookups 2nd 3rd 4th last cell search, extending 2nd 3rd 4th last cells distinguishing from bottommost cells 2nd last cell search, extending 2nd 3rd 4th layout worksheets 2nd 3rd 4th 5th 6th left outer joins less-than (LESSTHAN) sign LESSTHAN (less-than sign) libraries ADO library, referencing 2nd 3rd DAO library, referencing 2nd 3rd DLLs (dynamic link libraries) object libraries List command (Data menu) List menu commands Create List Total Row ListIndex property (combo boxes) lists creating 2nd 3rd Data Forms 2nd 3rd defined 2nd 3rd rows insert rows sort order sorting 2nd 3rd 4th structure of 2nd 3rd 4th 5th variable names 2nd 3rd 4th Locale property (CreateDatabase method) location of external data, specifying Choose Data Source dialog box Create New Data Source dialog box ODBC Microsoft Access Setup dialog box 2nd Select Database dialog box 2nd LockEdits property (OpenRecordset() function) LockFileName property (CreateDatabaseWithDAO() function) LockfileName variable locking records 2nd locking records pessimistic locking LockType property (recordsets) 2nd lookups labels versus codes 2nd 3rd 4th VLOOKUP function 2nd calculating commissions with 2nd 3rd column numbers lookup arrays lookup types lookup values two-column ranges 2nd 3rd loops Do While 2nd 3rd 4th 5th 6th For Each 2nd For-Next 2nd 3rd 4th inner For-Next loops 2nd simple example 2nd items numbers, looping with 2nd 3rd nested loops |