Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs

  • 5h 40m
  • Arvin Meyer, Douglas J. Steele
  • John Wiley & Sons (US)
  • 2010

If you use Access, you need this book

This is not another book about how Access works or how to design databases. It's a collection of real solutions to real-world database problems faced by every Access user and developer. If you do anything more with Access than make a simple list, you'll benefit from the wisdom these experts have gathered in more than a decade of assisting Access developers and users.

If you want practical solutions that achieve proven results, this is your book.

  • Simulate drag and drop in Access forms
  • Dynamically change sort order of a report
  • Create tables for SharePoint applications
  • Do high-speed lookups
  • Implement Soundex in Access
  • Use ActiveX controls in Access
  • Create reports that summarize data graphically
  • Add custom control types to Access forms

About the Authors

Arvin Meyer is Chief Database Architect at Data Strategies and a 10-year Microsoft MVP. He also performs Webmaster duties for The Access Web, the major Access FAQ resource in the world with over 35,000 hits daily. He is one of the technical editors of Microsoft Access Small Business Solutions, published by Wiley.

Douglas J. Steele has been an Access MVP since 1999. He has written about Access for Smart Access magazine, Advisor Media, and Database Journal, and is technical editor for the Access 2010 Bible, published by Wiley.

In this Book

  • Introduction
  • Creating Tables for Web Applications—An Introduction to Calculated Fields
  • Alternative to the Hyperlink Data Type
  • Fill a Table with Numbers
  • A Single Query to Do Both Updates and Insertions
  • Using a Cartesian Product to Generate a Calendar
  • Using a Multiselect List Box as a Query Parameter
  • Cascading Combo Boxes
  • Cascading Combo Boxes on Continuous Forms
  • Paired List Boxes
  • Marquees, Scrolling Messages, and Flashing Labels
  • Custom Tab Controls
  • Simulating Web-Style “Hover” Buttons
  • Custom Form Navigation Controls
  • Calendar Form
  • Simulating Drag-and-Drop in Access Forms
  • Providing Visual Feedback for Drag-and-Drop
  • Control List Boxes with Drag-and-Drop
  • Page 1 of N for Groups
  • Always Starting a Group on an Odd Page for Duplex Printing
  • Dynamically Changing the Sort Order of a Report
  • Week-at-a-Glance—Type Report
  • Day-at-a-Glance—Type Report
  • Useful String Functions
  • Useful Functions
  • Relinking Front-End Databases to Back-End Databases in the Same Folder
  • SaveAsText and LoadFromText—Undocumented Backup and Anti-Corruption Tricks
  • Reminders—Building Tickler Forms and Utilities
  • Using Disconnected Recordsets
  • Implementing Soundex
  • Charting Using Excel
  • Using the TreeView Control
  • Using the ListView Control
  • Adding Images to the TreeView Control
  • Using the TreeView and ListView Controls Together
  • Building an Access Web Application
  • Embedding a Web Control in a Form
  • Building a Time Picker in a Web Form—An Introduction to Web Macros
  • RSS Feeds
  • Detecting Whether You've Got Internet Connectivity
  • Drilling down to Data
  • Utility for Renaming a Form's Controls
  • Document Management Using Access
  • Ultra-Fast Searching