Access Cookbook - Ken Getz [372]
3.4.1. Problem
3.4.2. Solution
3.4.3. Discussion
3.5. Create a Page-Range Indicator on Each Page
3.5.1. Problem
3.5.2. Solution
3.5.3. Discussion
3.6. Create a Simple Bar Graph on a Report
3.6.1. Problem
3.6.2. Solution
3.6.3. Discussion
3.7. Create a Page Total
3.7.1. Problem
3.7.2. Solution
3.7.3. Discussion
3.8. Avoid Unwanted Blank Rows on Mailing Labels
3.8.1. Problem
3.8.2. Solution
3.8.3. Discussion
3.9. Suppress Printing a Report if There Are No Records to Print
3.9.1. Problem
3.9.2. Solution
3.9.3. Discussion
3.9.4. See Also
3.10. Print Different Headers or Footers on Odd and Even Pages
3.10.1. Problem
3.10.2. Solution
3.10.3. Discussion
3.11. Make a Vertical Line the Same Height as a CanGrow/CanShrink Control
3.11.1. Problem
3.11.2. Solution
3.11.3. Discussion
3.12. Alternate Gray Bars on My Reports
3.12.1. Problem
3.12.2. Solution
3.12.3. Discussion
3.13. Print Only Records Matching a Form's Filter
3.13.1. Problem
3.13.2. Solution
3.13.3. Discussion
3.14. Keep a Report from Breaking at an Inappropriate Place
3.14.1. Problem
3.14.2. Solution
3.14.3. Discussion
3.15. Customize a Report's Grouping and Sorting at Runtime
3.15.1. Problem
3.15.2. Solution
3.15.3. Discussion
4. Applications
4.1. Convert Queries into Embedded SQL Statements
4.1.1. Problem
4.1.2. Solution
4.1.3. Discussion
4.1.4. See Also
4.2. Build an Object Inventory
4.2.1. Problem
4.2.2. Solution
4.2.3. Discussion
4.2.3.1. Documenting all the containers
4.2.3.2. Creating the inventory table
4.2.3.3. Documenting each container
4.2.3.4. Avoiding errors
4.2.3.5. Comments
4.2.4. See Also
4.3. Verify That Objects Use Consistent Settings
4.3.1. Problem
4.3.2. Solution
4.3.3. Discussion
4.3.3.1. Creating the temporary tables and query
4.3.3.2. Getting ready to document items
4.3.3.3. Visiting all the objects
4.3.3.4. Recording property information
4.3.3.5. Comments
4.3.4. See Also
4.4. Hide Access Screen Activity
4.4.1. Problem
4.4.2. Solution
4.4.3. Discussion
4.4.3.1. Hiding reports in design view
4.4.4. See Also
4.5. Find out What Language Version of Access Is Installed
4.5.1. Problem
4.5.2. Solution
4.5.3. Discussion
4.6. Internationalize Text in Your Applications
4.6.1. Problem
4.6.2. Solution
4.6.3. Discussion
4.7. Change and Reset the Access Caption Bar
4.7.1. Problem
4.7.2. Solution
4.7.3. Discussion
4.8. Use the Windows File Open/Save Common Dialogs
4.8.1. Problem
4.8.2. Solution
4.8.3. Discussion
4.8.4. See Also
4.9. Clean Test Data out of a Database When You're Ready to Ship It
4.9.1. Problem
4.9.2. Solution
4.9.3. Discussion
4.9.4. See Also
4.10. Secure Your Access Database
4.10.1. Problem
4.10.2. Solution
4.10.3. Discussion
5. Printers
5.1. Retrieve a List of All the Installed Output Devices
5.1.1. Problem
5.1.2. Solution
5.1.3. Discussion
5.1.3.1. Adding items to a list box
5.1.4. See Also
5.2. Set and Retrieve the Name of the Default Output Device
5.2.1. Problem
5.2.2. Solution
5.2.3. Discussion
5.3. Programmatically Change Margin and Column Settings for Reports
5.3.1. Problem
5.3.2. Solution
5.3.3. Discussion
5.4. Programmatically Change Printer Options
5.4.1. Problem
5.4.2. Solution
5.4.3. Discussion
5.5. Programmatically Control the Paper Source
5.5.1. Problem
5.5.2. Solution
5.5.3. Discussion
5.6. Retrieve Information About a Report or Form's Selected Printer
5.6.1. Problem
5.6.2. Solution
5.7. Choose an Output Device at Runtime
5.7.1. Problem
5.7.2. Solution
5.7.3.