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

by Meyer, Arvin; Steele, Douglas J.

• ISBN13: 9780470591680
• ISBN10: 0470591684
• Edition: 1st
• Format: Paperback
• Copyright: 2010-10-12
• Publisher: Wiley

Summary

Two Microsoft Access MVPs show how you can become an Access power userMicrosoft 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 users are eager to make the most of Access, the most popular database system in the world These Microsoft MVPs examine every feature of Access 2010, providing advice on each core area of Access and techniques for capturing, sharing and reporting Access data across the full suite of Microsoft Office applications Each tip provides detailed solutions with clear instructions for implementation, and samples of all can be found on the companion Web siteAccess 2010 Solutions offers professional advice that enables every Access user to get greater value from the Access database system.

Author Biography

Arvin Meyer is Chief Database Architect at Data Strategies and a 10-year Microsoft MVP. He also performs Webmaster duties for The Access Web (www.mvps.org/access), 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.

Table of Contents

Acknowledgments

Introduction

Tables 1

Creating Tables for Web Applications

Alternative to the Hyperlink Data Type

Fill a Table with Numbers

Queries

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

Forms

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

Taking Advantage of Report Capabilities

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

Using VBA

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

Automating Applications and ActiveX Controls

Charting Using Excel

Using the TreeView Control

Using the ListView Control

Adding Images to the TreeView Control

Using the TreeView and ListView Controls Together

Access and the Web

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

Utilities

Drilling Down to Data

Utility for Renaming a Form's Controls

Document Management Using Access

Ultra-Fast Searching

Index

Table of Contents provided by Publisher. All Rights Reserved.