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