1. Chapter 1 Queries

   1. Specify Query Criteria at Runtime

   2. Using a Form-Based Parameter Query

   3. Limit the Items in One Combo Box Based on the Selected Item in Another

   4. Make Formatted Date Columns Sort Correctly in a Crosstab Query

   5. Group Mailing Labels by Address

   6. Use a Field in One Table to Update a Field in Another Table

   7. Use a VBA Variable to Filter a Query

   8. Use a Query to Retrieve a Random Set of Rows

   9. Create a Query That Will Show Aging of Receivables

   10. Create a Join That's Based on a Comparison Other than Equality

   11. Create a Query to Combine Data from Two Tables with Similar Structures

   12. Create a Combo Box That Allows a User to Select N/A

   13. Use a Query to Show the Relationship Between Employees and Supervisors

   14. Create a Query That Uses Case-Sensitive Criteria

   15. Use a Query to Create a New Table Complete with Indexes

   16. Save My Queries in a Table for Better Programmatic Access and Security

   17. Create a Recordset Based on a Parameter Query from VBA Code

2. Chapter 2 Forms

   1. Make Custom Templates for Forms and Reports

   2. Highlight the Current Field in Data-Entry Forms

   3. Restrict the User to a Single Row on a Form

   4. Use an Option Group to Collect and Display Textual Information

   5. Display Multiple Pages of Information on One Form

   6. Provide Record Navigation Buttons on a Form

   7. Size a Form's Controls to Match the Form's Size

   8. Make a Simple "Searching" List Box

   9. Create a Replacement for Access's InputBox

   10. Store the Sizes and Locations of Forms

   11. Open Multiple Instances of a Form

3. Chapter 3 Reports

   1. Create a Report with Line Numbers

   2. Print the Value of a Parameter on a Report

   3. Create a Report with Multiple Columns

   4. Print a Message on a Report if Certain Conditions Are Met

   5. Create a Page-Range Indicator on Each Page

   6. Create a Simple Bar Graph on a Report

   7. Create a Page Total

   8. Avoid Unwanted Blank Rows on Mailing Labels

   9. Suppress Printing a Report if There Are No Records to Print

   10. Print Different Headers or Footers on Odd and Even Pages

   11. Make a Vertical Line the Same Height as a CanGrow/CanShrink Control

   12. Alternate Gray Bars on My Reports

   13. Print Only Records Matching a Form's Filter

   14. Keep a Report from Breaking at an Inappropriate Place

   15. Customize a Report's Grouping and Sorting at Runtime

4. Chapter 4 Applications

   1. Convert Queries into Embedded SQL Statements

   2. Build an Object Inventory

   3. Verify That Objects Use Consistent Settings

   4. Hide Access Screen Activity

   5. Find out What Language Version of Access Is Installed

   6. Internationalize Text in Your Applications

   7. Change and Reset the Access Caption Bar

   8. Use the Windows File Open/Save Common Dialogs

   9. Clean Test Data out of a Database When You're Ready to Ship It

   10. Secure Your Access Database

5. Chapter 5 Printers

   1. Retrieve a List of All the Installed Output Devices

   2. Set and Retrieve the Name of the Default Output Device

   3. Programmatically Change Margin and Column Settings for Reports

   4. Programmatically Change Printer Options

   5. Programmatically Control the Paper Source

   6. Retrieve Information About a Report or Form's Selected Printer

   7. Choose an Output Device at Runtime

   8. Find Which Reports Are Not Set to Print to the Default Printer

6. Chapter 6 Data

   1. Save with Each Record the Name of the Last Person Who Edited It and the Date and Time

   2. Determine if You're on a New Record in a Form

   3. Find All Records with Names That Sound Alike

   4. Find the Median Value for a Field

   5. Quickly Find a Record in a Linked Table

   6. Get a Complete List of Field Properties from a Table or Query

   7. Create and Use Flexible AutoNumber Fields

   8. Back Up Selected Objects to Another Database

7. Chapter 7 VBA

   1. Build Up String References with Embedded Quotes

   2. Create a Global Procedure Stack

   3. Create an Execution Time Profiler

   4. Multitask Your VBA Code

   5. Programmatically Add Items to a List or Combo Box

   6. Pass a Variable Number of Parameters to a Procedure

   7. Sort an Array in VBA

   8. Fill a List Box with a List of Files

   9. Handle Object Properties, in General

   10. Detect Whether an Object Exists

8. Chapter 8 Optimization

   1. Accelerate the Load Time of Forms

   2. Make Slow Forms Run Faster

   3. Make Combo Boxes Load Faster

   4. Use Jet Engine Optimizations to Speed Up Queries

   5. Accelerate VBA Code

   6. Test the Comparative Benefits of Various Optimization Techniques

   7. Accelerate Multiuser Applications

   8. Accelerate Client/Server Applications

9. Chapter 9 User Interface

   1. Create Context-Sensitive Keyboard Shortcuts

   2. Create a Form with No Menu or Toolbar

   3. Create a Geographical Map Interface

   4. Mark a Record on a Form and Return to It Later

   5. Carry Data Forward from Record to Record

   6. Create a Combo Box That Accepts New Entries

   7. Create Animated Buttons

   8. Create an Expanding Dialog

   9. Use an ActiveX Control

   10. Create a Generic, Reusable Status Meter

10. Chapter 10 Multiuser Applications

    1. Properly Secure Your Database

    2. Maintain Multiple Synchronized Copies of the Same Database

    3. Create a Transaction Log

    4. Send Messages to Other Users Without Using Email

    5. Programmatically Track Users and Groups

    6. Adjust an Application Based on Who's Logged In

    7. List All Users with Blank Passwords

    8. Track Which Users Have a Shared Database Open

    9. Determine if a Record Is Locked and by Whom

    10. Set a Maximum Locking Interval for a Record

11. Chapter 11 Windows APIs

    1. Remove a Form's System Menu and Maximize/Minimize Buttons

    2. Flash a Window's Titlebar or Icon

    3. Classify Keypresses in a Language-Independent Manner

    4. Restrict Mouse Movement to a Specific Region

    5. Run Another Program and Pause Until It's Done

    6. Exit Windows Under Program Control

    7. Run the Application Associated with a Data File

    8. Check to See if an Application Is Already Running

    9. Retrieve a List of All Top-Level Windows

    10. Close a Running Windows Application

    11. Set File Date and Time Stamps

    12. Retrieve Information About Available Drives

    13. Collect and Display Information on the System and the Access Installation

    14. Create and Cancel Network Connections Programmatically

12. Chapter 12 Automation

    1. Play an Embedded Sound File from Within an Application

    2. Print an Access Report from Excel

    3. Use Excel's Functions from Within Access

    4. Perform a Mail Merge from Access to Word

    5. Add an Item to the Startup Group

    6. Send Access Data to Excel and Create an Excel Chart

    7. Create a PowerPoint Presentation from Access Data

    8. Add a Contact and Send Email Through Outlook

13. Chapter 13 Data Access Pages

    1. Replace Navigation Button Images with Your Own Images

    2. Use Labels or Other Controls for Record Navigation

    3. Change the Text Displayed with a Navigation Control

    4. Create a DAP that Allows You to Update Data

    5. Create One File to Store Connection Information for All DAPs in an Application

    6. Programmatically Change the Connection String for All Pages in a Database

    7. Change the Default Settings for New DAPs

    8. Use Parameters Set in One DAP to Open Another

14. Chapter 14 SQL Server

    1. Dynamically Link SQL Server Tables at Runtime

    2. Dynamically Connect to SQL Server from an ADP

    3. Share an ADP from a Shared Network Folder

    4. Fill the Drop-Down Lists When Using ServerFilterByForm in an ADP

    5. Pass Parameters to Stored Procedures from Pass-Through Queries in an MDB

    6. Pass Parameters to Stored Procedures from an ADP

    7. Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADP

    8. Reference Data from More than One SQL Server Database in an ADP

    9. Use Views to Update Data in an ADP When Users Don't Have Permissions on Tables

15. Chapter 15 Office Web and SharePoint

    1. Work with SharePoint Data from Access

    2. Create a SharePoint Data View Web Part Based on Access Data

    3. Conditionally Format a Data View Web Part

    4. Create a Master/Detail Page using Data View Web Parts

    5. Post Web Form Data to an Access Database

    6. Create a Web Frontend to an Access Table Using FrontPage

16. Chapter 16 Smart Tags

    1. Use the Built-in Smart Tags

    2. Display Multiple Smart Tags on Multiple Forms

    3. Display Smart Tags when Application Starts

    4. Execute a Smart Tag Action Without Displaying the Smart Tag

    5. Create a Smart Tag on a Table in an Access Project

    6. Create a Custom Smart Tag to Get a Weather Report

    7. Create a Custom Smart Tag DLL

17. Chapter 17 .NET

    1. Call a .NET Component from Access

    2. Call a .NET Component Containing a Parameterized Constructor

    3. Retrieve Access Data from an ASP.NET Application

    4. Call a Web Service from Access

    5. Work with a Web Service that Returns a DataSet

    6. Print an Access Report from .NET Windows Form Application

18. Chapter 18 XML

    1. XML Overview

    2. Import XML Structured as Elements

    3. Import XML into Existing Tables

    4. Import XML Using a Schema (XSD)

    5. Export XML

    6. Exporting Selected Columns to an HTML Table

    7. Export Unrelated Tables

    8. Export Using a Where Clause

    9. Export a Report

1. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Access Cookbook, Second Edition is a northern tamandua. The tamandua is also known as the collared, or lesser, anteater. There are two species of tamandua: the northern tamandua (Tamandua mexicana), found in Central America and the northwestern part of South America; and the southern tamandua (Tamandua tetradactyla), which can be found further south. Tamanduas have coarse, yellowish, or brownish fur with black markings and are about half the size of their rarer relatives, the giant anteaters (Myrmecophaga tridactyla). They can grow to be about 60 centimeters long, with a prehensile tail of approximately the same length, and reach weights of 6 to 13 pounds.

Tamanduas are occasionally found on the ground, but they prefer living in the trees, where they hunt for ant and termite nests. Like all anteaters, tamanduas have long snouts and extremely long tongues that they use to collect and eat their prey. Since no teeth are necessary for this kind of meal, anteaters' teeth have been reduced during their evolution. However, unlike the completely toothless giant anteaters, tamanduas still have some small teeth remaining (which are useful for consuming the fruits that supplement their diets). They use the sharp claws on their front paws to open ant and termite nests, but they are careful to not destroy the nests completely and take just a small portion of the colony before they go for the next nest. This strategy preserves the colonies for future feedings. Tamanduas are primarily active during the night and sleep through the day in hollow trees or the forks of trees, securing themselves by wrapping their tails around branches. Reg Aubry was the production editor and copyeditor for Access Cookbook, Second Edition. Darren Kelly, Genevieve d'Entremont, and Claire Cloutier provided quality control. Julie Hawks wrote the index.

Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from Cuvier's Animals. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. David Futato designed the CD-ROM label.

David Futato designed the interior layout. Julie Hawks converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia Free-Hand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was written by Rachel Wheeler.