Wrox.Expert.Access.2007.Programming.Nov.2007.pdf

:WroxPro 9/27/07 7:38 PM Page v
Expert
Access™ 2007 Programming
Rob Cooper and Michael Tucker
Wiley Publishing, Inc.
:WroxPro 9/27/07 7:38 PM Page ii
:WroxPro 9/27/07 7:38 PM Page i
Expert Access™ 2007 Programming
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv
Part I: Programming Access Applications . . . . . . . . . . . . . . . . . 1
Chapter 1: Overview of Programming for Access. . . . . . . . . . . . . . . . . . . . . . . 3
Chapter 2: Extending Applications Using the Windows API . . . . . . . . . . . . . . 11
Chapter 3: Programming Class Modules . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Chapter 4: Debugging, Error Handling, and Coding Practices . . . . . . . . . . . . 105
Part II: Data Manipulation 145
Chapter 5: Parsing Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147
Chapter 6: Using SQL to Retrieve Data and Manipulate Objects . . . . . . . . . 193
Chapter 7: Managing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263
Part III: Interacting with the Application 297
Chapter 8: Using Code to Add Advanced Functionality to Forms . . . . . . . . . 299
Chapter 9: Using Code to Add Advanced Functionality to Reports . . . . . . . . 357
Chapter 10: Using Automation to Add Functionality . . . . . . . . . . . . . . . . . . 387
Chapter 11: Creating Dynamic Ribbon Customizations . . . . . . . . . . . . . . . . 441
Part IV: Finalizing the Application 489
Chapter 12: Configuration and Extensibility . . . . . . . . . . . . . . . . . . . . . . . . 491
Chapter 13: Personalization and Security . . . . . . . . . . . . . . . . . . . . . . . . . . 525
Chapter 14: Deployment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 559
Chapter 15: Help and Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . .