Expert Access 2007 Programming.pdf

Expert

Access ™ 2007 Programming

Rob Cooper and Michael Tucker

Wiley Publishing, Inc.

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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 613

Appendix A: Programming Tips and Tricks . . . . . . . . . . . . . . . . . . . . . . . . . 637

Appendix B: Query Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 657

Appendix C: Pattern Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 665

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 673