Access Cookbook - Ken Getz [373]
5.8. Find Which Reports Are Not Set to Print to the Default Printer
5.8.1. Problem
5.8.2. Solution
5.8.3. Discussion
6. Data
6.1. Save with Each Record the Name of the Last Person Who Edited It and the Date and Time
6.1.1. Problem
6.1.2. Solution
6.1.3. Discussion
6.1.4. See Also
6.2. Determine if You're on a New Record in a Form
6.2.1. Problem
6.2.2. Solution
6.2.3. Discussion
6.3. Find All Records with Names That Sound Alike
6.3.1. Problem
6.3.2. Solution
6.3.3. Discussion
6.4. Find the Median Value for a Field
6.4.1. Problem
6.4.2. Solution
6.4.3. Discussion
6.5. Quickly Find a Record in a Linked Table
6.5.1. Problem
6.5.2. Solution
6.5.3. Discussion
6.6. Get a Complete List of Field Properties from a Table or Query
6.6.1. Problem
6.6.2. Solution
6.6.3. Discussion
6.6.4. See Also
6.7. Create and Use Flexible AutoNumber Fields
6.7.1. Problem
6.7.2. Solution
6.7.3. Discussion
6.8. Back Up Selected Objects to Another Database
6.8.1. Problem
6.8.2. Solution
6.8.3. Discussion
6.8.3.1. The MultiSelect property
6.8.3.2. Filling the lboObjects list box
6.8.3.3. The backup process
6.8.3.4. Comments
7. VBA
7.1. Build Up String References with Embedded Quotes
7.1.1. Problem
7.1.2. Solution
7.1.3. Discussion
7.2. Create a Global Procedure Stack
7.2.1. Problem
7.2.2. Solution
7.2.3. Discussion
7.3. Create an Execution Time Profiler
7.3.1. Problem
7.3.2. Solution
7.3.3. Steps
7.3.4. Discussion
7.4. Multitask Your VBA Code
7.4.1. Problem
7.4.2. Solution
7.4.3. Discussion
7.5. Programmatically Add Items to a List or Combo Box
7.5.1. Problem
7.5.2. Solution
7.5.2.1. Filling a list box by calling the AddItem method
7.5.2.2. Filling a list box by modifying the RowSource property
7.5.2.3. Filling a list box by creating a list-filling callback function
7.5.3. Discussion
7.5.3.1. Calling the AddItem method
7.5.3.2. Modifying the RowSource property
7.5.3.3. Creating a list-filling callback function
7.6. Pass a Variable Number of Parameters to a Procedure
7.6.1. Problem
7.6.2. Solution
7.6.3. Discussion
7.7. Sort an Array in VBA
7.7.1. Problem
7.7.2. Solution
7.7.3. Discussion
7.7.4. See Also
7.8. Fill a List Box with a List of Files
7.8.1. Problem
7.8.2. Solution
7.8.3. Discussion
7.9. Handle Object Properties, in General
7.9.1. Problem
7.9.2. Solution
7.9.3. Discussion
7.10. Detect Whether an Object Exists
7.10.1. Problem
7.10.2. Solution
7.10.3. Discussion
7.10.4. See Also
8. Optimization
8.1. Accelerate the Load Time of Forms
8.1.1. Problem
8.1.2. Solution
8.1.3. Discussion
8.2. Make Slow Forms Run Faster
8.2.1. Problem
8.2.2. Solution
8.2.2.1. Graphic and memo controls
8.2.2.2. Combo and list box controls
8.2.3. Discussion
8.3. Make Combo Boxes Load Faster
8.3.1. Problem
8.3.2. Solution
8.3.3. Discussion
8.4. Use Jet Engine Optimizations to Speed Up Queries
8.4.1. Problem
8.4.2. Solution
8.4.3. Discussion
8.5. Accelerate VBA Code
8.5.1. Problem
8.5.2. Solution
8.5.3. Discussion
8.6. Test the Comparative Benefits of Various Optimization Techniques
8.6.1. Problem
8.6.2. Solution
8.6.3. Discussion
8.7. Accelerate Multiuser Applications
8.7.1. Problem
8.7.2. Solution
8.7.3. Discussion
8.7.4. See Also
8.8. Accelerate Client/Server Applications
8.8.1. Problem
8.8.2. Solution
8.8.3. Discussion
9. User Interface
9.1. Create Context-Sensitive Keyboard Shortcuts
9.1.1. Problem
9.1.2. Solution
9.1.3. Discussion
9.2. Create a Form with No Menu or Toolbar
9.2.1. Problem
9.2.2.