| [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] ranges compared to arrays dynamically defined ranges, selecting 2nd external data ranges copying naming refreshing implicit intersections 2nd naming 2nd 3rd 4th dynamic range names 2nd 3rd 4th 5th 6th static range names 2nd properties 2nd 3rd 4th 5th 6th two-column ranges VLOOKUP function 2nd 3rd read-only mode 2nd 3rd 4th 5th 6th 7th 8th ReadOnly parameter (OpenDatabase method) rearranging data 2nd 3rd Paste Special command 2nd 3rd TRANSPOSE function 2nd 3rd reconfiguring pivot tables 2nd 3rd 4th 5th Record New Macro command (Macro menu) 2nd RecordCount variable recording macros 2nd recording macros 2nd 3rd RecordLastInspectDate function records adding with ADO (ActiveX Data Objects) 2nd 3rd adding with DAO 2nd 3rd 4th 5th adding with DAO (Data Access Objects) 2nd 3rd appending 2nd 3rd child records deleting 2nd deleting from Reservations application clean up 2nd code listing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th records, finding 2nd recordsets, establishing recurring reservations 2nd 3rd 4th 5th Sub statement user requests, verifying and confirming 2nd variable declarations 2nd 3rd editing with ADO (ActiveX Data Objects) 2nd 3rd 4th editing with DAO (Data Access Objects) 2nd 3rd 4th finding 2nd joins 2nd inner joins 2nd 3rd outer joins 2nd 3rd 4th parent records, choosing 2nd 3rd relational structures 2nd 3rd 4th 5th 6th 7th locking 2nd optimistic locking pessimistic locking parent records searching FindARecord() function 2nd SeekARecord() function 2nd updating 2nd 3rd 4th 5th variable numbers of 2nd 3rd 4th recordsets 2nd creating with ADO 2nd CursorLocation property 2nd CursorType property 2nd LockType property 2nd creating with DAO 2nd 3rd 4th 5th 6th dynaset-type recordsets 2nd snapshot-type recordsets 2nd specifying recordset type 2nd 3rd table-type recordsets 2nd 3rd esablishing recurring reservations (Reservations application) allowing for 2nd 3rd finding 2nd 3rd 4th 5th ReDim statement 2nd 3rd reference, passing by References command (Tools menu) References dialog box referencing object models referential integrity 2nd 3rd Refresh Data on File Open property (data ranges) Refresh every x Minutes option (pivot tables) Refresh External Data command (Data menu) Refresh on Open option 2nd 3rd 4th 5th 6th 7th 8th Refresh on Open option (pivot tables) 2nd refreshing external data ranges refreshing cache 2nd Refresh on Open versus Workbook_Open event 2nd 3rd 4th 5th 6th 7th 8th relational structures, creating with joins 2nd 3rd relationships defining 2nd identifying 2nd one-to-many 2nd one-to-one 2nd referential integrity 2nd 3rd viewing 2nd Relationships command (View menu) Relationships menu commands Edit Relationship Show Direct Show Table RemoveReservation() function Repeat Item Labels on Each Printed Page option (pivot tables) requesting passwords 2nd 3rd ReservationRange variable Reservations application deleting records from clean up 2nd code listing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th records, finding 2nd recordsets, establishing recurring records 2nd 3rd 4th 5th Sub statement user requests, verifying and confirming 2nd variable declarations 2nd 3rd goals 2nd 3rd parameterized queries layout requirements 2nd 3rd 4th 5th 6th memory arrays, populating 2nd reservation locations, finding 2nd 3rd 4th worksheets, clearing 2nd worksheets, putting data on 2nd 3rd 4th user forms, returning database data to 2nd 3rd recurring reservations 2nd 3rd reservation records, identifying 2nd 3rd 4th user forms, populating 2nd 3rd 4th 5th Resize function 2nd ResourceCount variable results of queries returning 2nd 3rd 4th RetrieveSingleDay query 2nd Return Data to Microsoft Excel command (File menu) right outer joins rightmost cells defined room reservations application. [See Reservations application] RoomArray array 2nd ROW function rows list rows insert rows transposing rows and columns 2nd Paste Special command 2nd TRANSPOSE function 2nd ROWS function rsRecordsToEdit variable 2nd Run command (Query menu) running queries 2nd 3rd queries with ADO (ActiveX Data Objects) Delete queries 2nd 3rd 4th Update queries 2nd 3rd 4th 5th 6th queries with DAO (Data Access Objects) Append queries 2nd 3rd 4th 5th Delete queries 2nd nonpersistent queries 2nd 3rd SQL parameters 2nd Update queries 2nd |