Microsoft Access Solutions: Tips, Tricks and Secrets from Microsoft Access MVPs -- Credits -- About the Authors -- About the Contributors -- Acknowledgments -- Contents -- Introduction -- Part I: Tables -- Tip 1: Creating Tables for Web Applications -- Objective -- Scenario -- Tables -- (Web) Queries -- (Web) Forms -- (Web) Reports -- (Web) Macros -- Modules -- Using This Tip -- Additional Information -- Tip 2: Alternative to the Hyperlink Data Type -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 3: Fill a Table with Numbers -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Part II: Queries -- Tip 4: A Single Query to Do Both Updates and Insertions -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 5: Using a Cartesian Product to Generate a Calendar -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 6: Using a Multiselect List Box as a Query Parameter -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Part III: Forms -- Tip 7: Cascading Combo Boxes -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 8: Cascading Combo Boxes on Continuous Forms -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 9: Paired List Boxes -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information.

Tip 10: Marquees, Scrolling Messages, and Flashing Labels -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 11: Custom Tab Controls -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 12: Simulating Web-Style "Hover" Buttons -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 13: Custom Form Navigation Controls -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 14: Calendar Form -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 15: Simulating Drag-and-Drop in Access Forms -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 16: Providing Visual Feedback for Drag-and-Drop -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 17: Control List Boxes with Drag-and-Drop -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Part IV: Taking Advantage of Report Capabilities -- Tip 18: Page 1 of N for Groups -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 19: Always Starting a Group on an Odd Page for Duplex Printing -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information.

Tip 20: Dynamically Changing the Sort Order of a Report -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 22: Week-at-a-Glance-Type Report -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 22: Day-at-a-Glance-Type Report -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Part V: Using VBA -- Tip 23: Useful String Functions -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 24: Useful Functions -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 25: Relinking Front-End Databases to Back-End Databases in the Same Folder -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 26: SaveAsText and LoadFromText: Undocumented Backup and Anti-Corruption Tricks -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 27: Reminders-Building Tickler Forms and Utilities -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 28: Using Disconnected Recordsets -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 29: Implementing Soundex -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information.

Part VI: Automating Applications and ActiveX Controls -- Tip 30: Charting Using Excel -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 31: Using the TreeView Control -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 32: Using the ListView Control -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 33: Adding Images to the TreeView Control -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 34: Using the TreeView and ListView Controls Together -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Part VII: Access and the Web -- Tip 35: Building an Access Web Application -- Objective -- Scenario -- Working with SharePoint -- Tables -- Queries -- Forms -- Reports -- Macros -- Publishing a SharePoint Database -- Modules -- Using This Tip -- Additional Information -- Tip 36: Embedding a Web Control in a Form -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 37: Building a Time Picker in a Web Form: An Introduction to Web Macros -- Objective -- Scenario -- Tables -- (Web) Queries -- (Web) Forms -- (Web) Reports -- (Web) Macros -- Modules -- Using This Tip -- Additional Information -- Tip 38: RSS Feeds -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 39: Detecting Whether You've Got Internet Connectivity -- Objective -- Scenario -- Tables -- Queries -- Forms.

Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Part VIII: Utilites -- Tip 40: Drilling Down to Data -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 41: Utility for Renaming a Form's Controls -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 42: Document Management Using Access -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Tip 43: Ultra-Fast Searching -- Objective -- Scenario -- Tables -- Queries -- Forms -- Reports -- Macros -- Modules -- Using This Tip -- Additional Information -- Index.