Access Cookbook, 2nd Edition |
By Andy Baron, Ken Getz, Paul Litwin |
| |
Publisher | : O'Reilly |
Pub Date | : March 2004 |
ISBN | : 0-596-00678-0 |
Pages | : 840 |
| | 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 |