| [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] FieldLength variable fields Boolean fields returning to worksheets 2nd 3rd defining 2nd 3rd 4th 5th list fields 2nd 3rd 4th names choosing 2nd 3rd 4th 5th Name AutoCorrect feature spaces in 2nd 3rd number of 2nd setting type of 2nd 3rd 4th Fields Per Column option (pivot tables) Fields Per Row option (pivot tables) File menu commands Close and return to Microsoft Excel Return Data to Microsoft Excel Save files DSN files 2nd 3rd 4th 5th (data source name) filtering file types 2nd 3rd flat files query files UDL (universal data link) files 2nd 3rd 4th 5th 6th workgroup information files 2nd 3rd 4th Fill Down Formulas in Columns Adjacent to Table property (data ranges) Filter command (Data menu) Filter function Filter menu commands Advanced Filter AutoFilter Show All FilterIndex parameter (GetOpenFilename method) filtering data 2nd Advanced Filter 2nd 3rd 4th 5th criteria 2nd example 2nd forumulas 2nd AutoFilter 2nd 3rd 4th 5th 6th Custom AutoFilter 2nd 3rd dropdowns 2nd other criteria 2nd 3rd formulas as filter criteria 2nd filters Advanced Filter 2nd 3rd 4th 5th criteria 2nd example 2nd forumulas 2nd AutoFilter 2nd 3rd 4th 5th 6th Custom AutoFilter 2nd 3rd dropdowns 2nd other criteria 2nd 3rd formulas as filter criteria 2nd financial data returning from Web sites 2nd 3rd 4th 5th Find command (Edit menu) FindARecord() function 2nd FindFirst function 2nd finding records 2nd FindARecord() function 2nd Reservations application 2nd SeekARecord() function 2nd finding data INDEX function 2nd combining with MATCH function 2nd 3rd two-way arrays 2nd 3rd MATCH function 2nd 3rd approximate matches 2nd 3rd 4th 5th bottommost cell, distinguishing from last cell 2nd combining with INDEX function 2nd 3rd last cell search, extending 2nd 3rd 4th lookup types two-way arrays 2nd 3rd OFFSET function BaseCells 2nd example 2nd Height/Width arguments 2nd 3rd multiple cells, returning 2nd 3rd FindLast function FindNext function FindPrevious function FindReservationDetailIDInDB method FindReservationMasterIDInDB method 2nd flat files flat-file workarounds 2nd 3rd 4th flexibility 2nd 3rd 4th For Each loops 2nd For Empty Cells, Show option (pivot tables) For Error Values, Show option (pivot tables) For-Next loops 2nd 3rd 4th inner For-Next loops 2nd simple example 2nd Form command (Data menu) Format menu commands Cells format 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 forms Data Forms 2nd 3rd user forms,returning database data to 2nd 3rd records, identifying 2nd 3rd 4th recurring data 2nd 3rd user forms, populating 2nd 3rd 4th 5th formulas array formulas 2nd 3rd as filter criteria 2nd naming 2nd 3rd FromDBtoForm() function functions AddComment AddNew AddRecordsWithDAO() 2nd 3rd ADDRESS AddStocks() 2nd 3rd AREAS Clear COLUMN COLUMNS CopyFromRecordset 2nd 3rd 4th 5th ADO recordsets 2nd DAO recordsets 2nd CopyFromRecordsetWithADO() 2nd CopyFromRecordsetWithDAO() COUNT CreateDatabaseWithDAO 2nd 3rd 4th CreateDatabaseWithDAO() 2nd 3rd CreateQueryDef DATE() defined DeleteOldOrders DeleteOldOrders() DeleteOldOrdersWithSQL() 2nd DeleteOldRecords() 2nd 3rd DeleteOldRecordsWithString1() 2nd Dir Driver() 2nd 3rd Edit End End() Filter FindARecord() 2nd FindFirst 2nd FindLast FindNext FindPrevious FromDBtoForm GetConnectionStrings 2nd 3rd GETDATE() GetMasterID() 2nd 3rd GETPIVOTDATA entering automatically 2nd Excel 2002/Excel 2003 2nd Excel 97/Excel 2000 2nd when to use 2nd HLOOKUP INDEX combining with MATCH function 2nd 3rd finding data with 2nd two-way arrays 2nd 3rd INDIRECT MakeNewTableWithDAO() 2nd 3rd 4th 5th 6th MakeTheConnection 2nd MATCH Match 2nd MATCH approximate matches 2nd 3rd 4th 5th bottommost cell, distinguishing from last cell 2nd combining with INDEX function 2nd 3rd finding data with 2nd 3rd last cell search, extending 2nd 3rd 4th lookup types two-way arrays 2nd 3rd NewShortStayTable() 2nd 3rd 4th OFFSET 2nd 3rd Offset 2nd OFFSET BaseCells 2nd example 2nd Height/Width arguments 2nd 3rd multiple cells, returning 2nd 3rd Open OpenRecordset() 2nd 3rd 4th overworking 2nd 3rd 4th 5th RecordLastInspectDate RemoveReservation() Resize 2nd ROW ROWS Seek() SeekARecord() 2nd SellStocks() 2nd 3rd 4th Text 2nd TRANSPOSE 2nd 3rd TRANSPOSE function 2nd 3rd Ucase Update 2nd 3rd UpdateEmployeeData() 2nd UpdatePhysicalDates() VLOOKUP 2nd 3rd 4th 5th calculating commissions with 2nd 3rd column numbers lookup arrays lookup types lookup values two-column ranges 2nd 3rd Workbook_BeforeClose() 2nd |