| |  | Copyright |
| | | Preface |
| |
| | What This Book Is About |
| |
| | Who This Book Is For |
| |
| | What You Need to Use This Book |
| |
| | How This Book Is Organized |
| |
| | What We Left Out |
| |
| | Conventions Used in This Book |
| |
| | Comments and Questions |
| |
| | Acknowledgments |
|
| | |
Chapter 1.
Queries |
| |
| |
Section 1.1.
Specify Query Criteria at Runtime |
| |
| |
Section 1.2.
Using a Form-Based Parameter Query |
| |
| |
Section 1.3.
Limit the Items in One Combo Box Based on the Selected Item in Another |
| |
| |
Section 1.4.
Make Formatted Date Columns Sort Correctly in a Crosstab Query |
| |
| |
Section 1.5.
Group Mailing Labels by Address |
| |
| |
Section 1.6.
Use a Field in One Table to Update a Field in Another Table |
| |
| |
Section 1.7.
Use a VBA Variable to Filter a Query |
| |
| |
Section 1.8.
Use a Query to Retrieve a Random Set of Rows |
| |
| |
Section 1.9.
Create a Query That Will Show Aging of Receivables |
| |
| |
Section 1.10.
Create a Join That's Based on a Comparison Other than Equality |
| |
| |
Section 1.11.
Create a Query to Combine Data from Two Tables with Similar Structures |
| |
| |
Section 1.12.
Create a Combo Box That Allows a User to Select N/A |
| |
| |
Section 1.13.
Use a Query to Show the Relationship Between Employees and Supervisors |
| |
| |
Section 1.14.
Create a Query That Uses Case-Sensitive Criteria |
| |
| |
Section 1.15.
Use a Query to Create a New Table Complete with Indexes |
| |
| |
Section 1.16.
Save My Queries in a Table for Better Programmatic Access and Security |
| |
| |
Section 1.17.
Create a Recordset Based on a Parameter Query from VBA Code |
|
| | |
Chapter 2.
Forms |
| |
| |
Section 2.1.
Make Custom Templates for Forms and Reports |
| |
| |
Section 2.2.
Highlight the Current Field in Data-Entry Forms |
| |
| |
Section 2.3.
Restrict the User to a Single Row on a Form |
| |
| |
Section 2.4.
Use an Option Group to Collect and Display Textual Information |
| |
| |
Section 2.5.
Display Multiple Pages of Information on One Form |
| |
| |
Section 2.6.
Provide Record Navigation Buttons on a Form |
| |
| |
Section 2.7.
Size a Form's Controls to Match the Form's Size |
| |
| |
Section 2.8.
Make a Simple "Searching" List Box |
| |
| |
Section 2.9.
Create a Replacement for Access's InputBox |
| |
| |
Section 2.10.
Store the Sizes and Locations of Forms |
| |
| |
Section 2.11.
Open Multiple Instances of a Form |
|
| | |
Chapter 3.
Reports |
| |
| |
Section 3.1.
Create a Report with Line Numbers |
| |
| |
Section 3.2.
Print the Value of a Parameter on a Report |
| |
| |
Section 3.3.
Create a Report with Multiple Columns |
| |
| |
Section 3.4.
Print a Message on a Report if Certain Conditions Are Met |
| |
| |
Section 3.5.
Create a Page-Range Indicator on Each Page |
| |
| |
Section 3.6.
Create a Simple Bar Graph on a Report |
| |
| |
Section 3.7.
Create a Page Total |
| |
| |
Section 3.8.
Avoid Unwanted Blank Rows on Mailing Labels |
| |
| |
Section 3.9.
Suppress Printing a Report if There Are No Records to Print |
| |
| |
Section 3.10.
Print Different Headers or Footers on Odd and Even Pages |
| |
| |
Section 3.11.
Make a Vertical Line the Same Height as a CanGrow/CanShrink Control |
| |
| |
Section 3.12.
Alternate Gray Bars on My Reports |
| |
| |
Section 3.13.
Print Only Records Matching a Form's Filter |
| |
| |
Section 3.14.
Keep a Report from Breaking at an Inappropriate Place |
| |
| |
Section 3.15.
Customize a Report's Grouping and Sorting at Runtime |
|
| | |
Chapter 4.
Applications |
| |
| |
Section 4.1.
Convert Queries into Embedded SQL Statements |
| |
| |
Section 4.2.
Build an Object Inventory |
| |
| |
Section 4.3.
Verify That Objects Use Consistent Settings |
| |
| |
Section 4.4.
Hide Access Screen Activity |
| |
| |
Section 4.5.
Find out What Language Version of Access Is Installed |
| |
| |
Section 4.6.
Internationalize Text in Your Applications |
| |
| |
Section 4.7.
Change and Reset the Access Caption Bar |
| |
| |
Section 4.8.
Use the Windows File Open/Save Common Dialogs |
| |
| |
Section 4.9.
Clean Test Data out of a Database When You're Ready to Ship It |
| |
| |
Section 4.10.
Secure Your Access Database |
|
| | |
Chapter 5.
Printers |
| |
| |
Section 5.1.
Retrieve a List of All the Installed Output Devices |
| |
| |
Section 5.2.
Set and Retrieve the Name of the Default Output Device |
| |
| |
Section 5.3.
Programmatically Change Margin and Column Settings for Reports |
| |
| |
Section 5.4.
Programmatically Change Printer Options |
| |
| |
Section 5.5.
Programmatically Control the Paper Source |
| |
| |
Section 5.6.
Retrieve Information About a Report or Form's Selected Printer |
| |
| |
Section 5.7.
Choose an Output Device at Runtime |
| |
| |
Section 5.8.
Find Which Reports Are Not Set to Print to the Default Printer |
|
| | |
Chapter 6.
Data |
| |
| |
Section 6.1.
Save with Each Record the Name of the Last Person Who Edited It and the Date and Time |
| |
| |
Section 6.2.
Determine if You're on a New Record in a Form |
| |
| |
Section 6.3.
Find All Records with Names That Sound Alike |
| |
| |
Section 6.4.
Find the Median Value for a Field |
| |
| |
Section 6.5.
Quickly Find a Record in a Linked Table |
| |
| |
Section 6.6.
Get a Complete List of Field Properties from a Table or Query |
| |
| |
Section 6.7.
Create and Use Flexible AutoNumber Fields |
| |
| |
Section 6.8.
Back Up Selected Objects to Another Database |
|
| | |
Chapter 7.
VBA |
| |
| |
Section 7.1.
Build Up String References with Embedded Quotes |
| |
| |
Section 7.2.
Create a Global Procedure Stack |
| |
| |
Section 7.3.
Create an Execution Time Profiler |
| |
| |
Section 7.4.
Multitask Your VBA Code |
| |
| |
Section 7.5.
Programmatically Add Items to a List or Combo Box |
| |
| |
Section 7.6.
Pass a Variable Number of Parameters to a Procedure |
| |
| |
Section 7.7.
Sort an Array in VBA |
| |
| |
Section 7.8.
Fill a List Box with a List of Files |
| |
| |
Section 7.9.
Handle Object Properties, in General |
| |
| |
Section 7.10.
Detect Whether an Object Exists |
|
| | |
Chapter 8.
Optimization |
| |
| |
Section 8.1.
Accelerate the Load Time of Forms |
| |
| |
Section 8.2.
Make Slow Forms Run Faster |
| |
| |
Section 8.3.
Make Combo Boxes Load Faster |
| |
| |
Section 8.4.
Use Jet Engine Optimizations to Speed Up Queries |
| |
| |
Section 8.5.
Accelerate VBA Code |
| |
| |
Section 8.6.
Test the Comparative Benefits of Various Optimization Techniques |
| |
| |
Section 8.7.
Accelerate Multiuser Applications |
| |
| |
Section 8.8.
Accelerate Client/Server Applications |
|
| | |
Chapter 9.
User Interface |
| |
| |
Section 9.1.
Create Context-Sensitive Keyboard Shortcuts |
| |
| |
Section 9.2.
Create a Form with No Menu or Toolbar |
| |
| |
Section 9.3.
Create a Geographical Map Interface |
| |
| |
Section 9.4.
Mark a Record on a Form and Return to It Later |
| |
| |
Section 9.5.
Carry Data Forward from Record to Record |
| |
| |
Section 9.6.
Create a Combo Box That Accepts New Entries |
| |
| |
Section 9.7.
Create Animated Buttons |
| |
| |
Section 9.8.
Create an Expanding Dialog |
| |
| |
Section 9.9.
Use an ActiveX Control |
| |
| |
Section 9.10.
Create a Generic, Reusable Status Meter |
|
| | |
Chapter 10.
Multiuser Applications |
| |
| |
Section 10.1.
Properly Secure Your Database |
| |
| |
Section 10.2.
Maintain Multiple Synchronized Copies of the Same Database |
| |
| |
Section 10.3.
Create a Transaction Log |
| |
| |
Section 10.4.
Send Messages to Other Users Without Using Email |
| |
| |
Section 10.5.
Programmatically Track Users and Groups |
| |
| |
Section 10.6.
Adjust an Application Based on Who's Logged In |
| |
| |
Section 10.7.
List All Users with Blank Passwords |
| |
| |
Section 10.8.
Track Which Users Have a Shared Database Open |
| |
| |
Section 10.9.
Determine if a Record Is Locked and by Whom |
| |
| |
Section 10.10.
Set a Maximum Locking Interval for a Record |
|
| | |
Chapter 11.
Windows APIs |
| |
| |
Section 11.1.
Remove a Form's System Menu and Maximize/Minimize Buttons |
| |
| |
Section 11.2.
Flash a Window's Titlebar or Icon |
| |
| |
Section 11.3.
Classify Keypresses in a Language-Independent Manner |
| |
| |
Section 11.4.
Restrict Mouse Movement to a Specific Region |
| |
| |
Section 11.5.
Run Another Program and Pause Until It's Done |
| |
| |
Section 11.6.
Exit Windows Under Program Control |
| |
| |
Section 11.7.
Run the Application Associated with a Data File |
| |
| |
Section 11.8.
Check to See if an Application Is Already Running |
| |
| |
Section 11.9.
Retrieve a List of All Top-Level Windows |
| |
| |
Section 11.10.
Close a Running Windows Application |
| |
| |
Section 11.11.
Set File Date and Time Stamps |
| |
| |
Section 11.12.
Retrieve Information About Available Drives |
| |
| |
Section 11.13.
Collect and Display Information on the System and the Access Installation |
| |
| |
Section 11.14.
Create and Cancel Network Connections Programmatically |
|
| | |
Chapter 12.
Automation |
| |
| |
Section 12.1.
Play an Embedded Sound File from Within an Application |
| |
| |
Section 12.2.
Print an Access Report from Excel |
| |
| |
Section 12.3.
Use Excel's Functions from Within Access |
| |
| |
Section 12.4.
Perform a Mail Merge from Access to Word |
| |
| |
Section 12.5.
Add an Item to the Startup Group |
| |
| |
Section 12.6.
Send Access Data to Excel and Create an Excel Chart |
| |
| |
Section 12.7.
Create a PowerPoint Presentation from Access Data |
| |
| |
Section 12.8.
Add a Contact and Send Email Through Outlook |
|
| | |
Chapter 13.
Data Access Pages |
| |
| |
Section 13.1.
Replace Navigation Button Images with Your Own Images |
| |
| |
Section 13.2.
Use Labels or Other Controls for Record Navigation |
| |
| |
Section 13.3.
Change the Text Displayed with a Navigation Control |
| |
| |
Section 13.4.
Create a DAP that Allows You to Update Data |
| |
| |
Section 13.5.
Create One File to Store Connection Information for All DAPs in an Application |
| |
| |
Section 13.6.
Programmatically Change the Connection String for All Pages in a Database |
| |
| |
Section 13.7.
Change the Default Settings for New DAPs |
| |
| |
Section 13.8.
Use Parameters Set in One DAP to Open Another |
|
| | |
Chapter 14.
SQL Server |
| |
| |
Section 14.1.
Dynamically Link SQL Server Tables at Runtime |
| |
| |
Section 14.2.
Dynamically Connect to SQL Server from an ADP |
| |
| |
Section 14.3.
Share an ADP from a Shared Network Folder |
| |
| |
Section 14.4.
Fill the Drop-Down Lists When Using ServerFilterByForm in an ADP |
| |
| |
Section 14.5.
Pass Parameters to Stored Procedures from Pass-Through Queries in an MDB |
| |
| |
Section 14.6.
Pass Parameters to Stored Procedures from an ADP |
| |
| |
Section 14.7.
Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADP |
| |
| |
Section 14.8.
Reference Data from More than One SQL Server Database in an ADP |
| |
| |
Section 14.9.
Use Views to Update Data in an ADP When Users Don't Have Permissions on Tables |
|
| | |
Chapter 15.
Office Web and SharePoint |
| |
| |
Section 15.1.
Work with SharePoint Data from Access |
| |
| |
Section 15.2.
Create a SharePoint Data View Web Part Based on Access Data |
| |
| |
Section 15.3.
Conditionally Format a Data View Web Part |
| |
| |
Section 15.4.
Create a Master/Detail Page using Data View Web Parts |
| |
| |
Section 15.5.
Post Web Form Data to an Access Database |
| |
| |
Section 15.6.
Create a Web Frontend to an Access Table Using FrontPage |
|
| | |
Chapter 16.
Smart Tags |
| |
| |
Section 16.1.
Use the Built-in Smart Tags |
| |
| |
Section 16.2.
Display Multiple Smart Tags on Multiple Forms |
| |
| |
Section 16.3.
Display Smart Tags when Application Starts |
| |
| |
Section 16.4.
Execute a Smart Tag Action Without Displaying the Smart Tag |
| |
| |
Section 16.5.
Create a Smart Tag on a Table in an Access Project |
| |
| |
Section 16.6.
Create a Custom Smart Tag to Get a Weather Report |
| |
| |
Section 16.7.
Create a Custom Smart Tag DLL |
|
| | |
Chapter 17.
.NET |
| |
| |
Section 17.1.
Call a .NET Component from Access |
| |
| |
Section 17.2.
Call a .NET Component Containing a Parameterized Constructor |
| |
| |
Section 17.3.
Retrieve Access Data from an ASP.NET Application |
| |
| |
Section 17.4.
Call a Web Service from Access |
| |
| |
Section 17.5.
Work with a Web Service that Returns a DataSet |
| |
| |
Section 17.6.
Print an Access Report from .NET Windows Form Application |
|
| | |
Chapter 18.
XML |
| |
| | XML Overview |
| |
| |
Section 18.1.
Import XML Structured as Elements |
| |
| |
Section 18.2.
Import XML into Existing Tables |
| |
| |
Section 18.3.
Import XML Using a Schema (XSD) |
| |
| |
Section 18.4.
Export XML |
| |
| |
Section 18.5.
Exporting Selected Columns to an HTML Table |
| |
| |
Section 18.6.
Export Unrelated Tables |
| |
| |
Section 18.7.
Export Using a Where Clause |
| |
| |
Section 18.8.
Export a Report |
|
| | | Colophon |
| | | Index |
