| [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] Page Layout option (pivot tables) Parameter object parameterized queries, populating worksheets with layout requirements 2nd 3rd 4th 5th 6th memory arrays, populating 2nd recordsets, looping through 2nd 3rd 4th worksheets, clearing 2nd worksheets, putting data on 2nd 3rd 4th parameters (queries) 2nd parameters (SQL queries) 2nd parent records joining with child records 2nd inner joins 2nd 3rd outer joins 2nd 3rd 4th parent record selection 2nd 3rd relational structures 2nd 3rd passing by reference passing by vaue passwords Jet databases 2nd 3rd 4th requesting 2nd 3rd Paste Special command (Edit menu) 2nd 3rd 4th 5th Paste Special dialog box Paste Special menu commands Transpose pessimistic locking Pivot Table Wizard importing data 2nd pivot tables 2nd 3rd advantages of 2nd 3rd creating 2nd 3rd date/time fields, grouping 2nd 3rd importing data to 2nd populating pivot tables 2nd Refresh on Open versus Workbook_Open event 2nd 3rd 4th 5th 6th 7th 8th refreshing cache 2nd null values, avoiding 2nd 3rd 4th 5th numeric fields, grouping 2nd populating 2nd reconfiguring 2nd 3rd 4th 5th retrieving data with GETPIVOTDATA function entering GETPIVOTDATA automatically 2nd Excel 2002/Excel 2003 2nd Excel 97/Excel 2000 2nd when to use 2nd table options AutoFormat Table Background Query Enable Drill to Details Fields Per Column Fields Per Row For Empty Cells, Show For Error Values, Show Grand Totals for Columns Grand Totals for Rows Merge Labels Optimize Memory Page Layout Preserve Formatting 2nd Refresh Every x Minutes Refresh on Open 2nd Repeat Item Labels on Each Printed Page Save Data with Table Layout 2nd Save Password PivotTable and PivotChart Report command (Data menu) PivotTable Options dialog box PivotTable Wizard 2nd 3rd populating pivot tables 2nd populating worksheets parameterized queries layout requirements 2nd 3rd 4th 5th 6th memory arrays, populating 2nd recordsets, looping through 2nd 3rd 4th worksheets, clearing 2nd worksheets, putting data on 2nd 3rd 4th preexisting databases, checking for 2nd 3rd 4th 5th 6th preparing data for pivot tables null values, avoiding 2nd 3rd 4th 5th numeric fields, grouping 2nd time/date fields, grouping 2nd 3rd Preserve Formatting option (pivot tables) 2nd primary keys 2nd 3rd 4th 5th prm object variable procedures, stored 2nd . [See also queries] projects defined properites MultiSelect (list boxs) properties ConnectionString (Connection object) 2nd 3rd 4th 5th 6th 7th 8th 9th CursorLocation (recordsets) 2nd CursorType (recordsets) 2nd data ranges 2nd 3rd 4th 5th 6th defined ListIndex (combo boxes) LockType (recordsets) 2nd Visible (worksheets) 2nd Properties window (VBE) pt variable 2nd 3rd |