Access Solutions

Two Microsoft Access MVPs show how you can become an Access power user Microsoft Access is the world s leading database system, with millions of users and hundreds of thousands of developers. The best practices, tips, and techniques in this book can turn users into power users. Millions of eager users make Access the most popular database system in the world These Microsoft MVPs exploit key features in Access, providing advice on techniques for capturing, sharing and reporting Access data. Each tip provides detailed solutions with clear instructions for implementation, and samples of all can be found on the companion Web site Access 2010 Solutions offers professional advice that enables every Access user to get greater value from the Access database system.

Two Microsoft Access MVPs show how you can become an Accesspower user* Microsoft Access is the world's leading database systemwith millions of users and hundreds of thousands of developers. Thebest practices, tips, and techniques in this book can turn usersinto power users.* Millions of eager users make Access the most popular databasesystem in the worldThese Microsoft MVPs exploit key features in Access, providingadvice on techniques for capturing, sharing and reporting Accessdata.* Each tip provides detailed solutions with clear instructionsfor implementation, and samples of all can be found on thecompanion Web siteAccess 2010 Solutions offers professional advice thatenables every Access user to get greater value from the Accessdatabase system.

Introduction xxiPart I Tables 1Tip 1 Creating Tables for Web Applications 3Tip 2 Alternative to the Hyperlink Data Type 9Tip 3 Fill a Table with Numbers 17Part II Queries 23Tip 4 A Single Query to Do Both Updates and Insertions 25Tip 5 Using a Cartesian Product to Generate a Calendar 31Tip 6 Using a Multiselect List Box as a Query Parameter 39Part III Forms 55Tip 7 Cascading Combo Boxes 57Tip 8 Cascading Combo Boxes on Continuous Forms 65Tip 9 Paired List Boxes 75Tip 10 Marquees, Scrolling Messages, and Flashing Labels 89Tip 11 Custom Tab Controls 99Tip 12 Simulating Web-Style "Hover" Buttons 109Tip 13 Custom Form Navigation Controls 115Tip 14 Calendar Form 121Tip 15 Simulating Drag-and-Drop in Access Forms 129Tip 16 Providing Visual Feedback for Drag-and-Drop 139Tip 17 Control List Boxes with Drag-and-Drop 149Part IV Taking Advantage of Report Capabilities 165Tip 18 Page 1 of N for Groups 167Tip 19 Always Starting a Group on an Odd Page for Duplex Printing 175Tip 20 Dynamically Changing the Sort Order of a Report 183Tip 21 Week-at-a-Glance-Type Report 197Tip 22 Day-at-a-Glance-Type Report 209Part V Using VBA 221Tip 23 Useful String Functions 223Tip 24 Useful Functions 245Tip 25 Relinking Front-End Databases to Back-End Databases in the Same Folder 271Tip 26 SaveAsText and LoadFromText: Undocumented Backup and Anti-Corruption Tricks 277Tip 27 Reminders--Building Tickler Forms and Utilities 287Tip 28 Using Disconnected Recordsets 297Tip 29 Implementing Soundex 311Part VI Automating Applications and ActiveX Controls 329Tip 30 Charting Using Excel 331Tip 31 Using the TreeView Control 343Tip 32 Using the ListView Control 359Tip 33 Adding Images to the TreeView Control 383Tip 34 Using the TreeView and ListView Controls Together 399Part VII Access and the Web 417Tip 35 Building an Access Web Application 419Tip 36 Embedding a Web Control in a Form 449Tip 37 Building a Time Picker in a Web Form: An Introduction to Web Macros 459Tip 38 RSS Feeds 471Tip 39 Detecting Whether You've Got Internet Connectivity 487Part VIII Utilities 493Tip 40 Drilling Down to Data 495Tip 41 Utility for Renaming a Form's Controls 501Tip 42 Document Management Using Access 507Tip 43 Ultra-Fast Searching 529Index 539