• Main Page
  • Table of content
  • 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
    • 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
  • Chapter 2. Forms
    • 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
  • Chapter 3. Reports
    • 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
  • Chapter 4. Applications
    • 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
  • Chapter 5. Printers
    • 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
  • Chapter 6. Data
    • 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
  • Chapter 7. VBA
    • 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
  • Chapter 8. Optimization
    • 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
  • Chapter 9. User Interface
    • 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
  • Chapter 11. Windows APIs
    • 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
  • Chapter 12. Automation
    • 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
  • Chapter 13. Data Access Pages
    • 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
  • Chapter 14. SQL Server
    • 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
  • Chapter 16. Smart Tags
    • 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
  • Chapter 17. .NET
    • 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
  • Chapter 18. XML
    • XML Overview
    • 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.4 Export XML
    • Recipe 18.5 Exporting Selected Columns to an HTML Table
    • Recipe 18.6 Export Unrelated Tables
    • Recipe 18.7 Export Using a Where Clause
    • Recipe 18.8 Export a Report
  • Colophon
  • Index
    • Index SYMBOL
    • Index A
    • Index B
    • Index C
    • Index D
    • Index E
    • Index F
    • Index G
    • Index H
    • Index I
    • Index J
    • Index K
    • Index L
    • Index M
    • Index N
    • Index O
    • Index P
    • Index Q
    • Index R
    • Index S
    • Index T
    • Index U
    • Index V
    • Index W
    • Index X