Chapter 11. Advanced Access Programmin

We covered a lot of ground in prior chapters exploring how to use VBA to extend your Access applications. This chapter will discuss some advanced programming techniques, but it is not meant to provide exhaustive coverage. This chapter covers the following techniques:

  • Declaring and using standard and external DLLs

  • Using automation to control Excel, Word, and Outlook from your Access applications

  • Adding ActiveX controls to your forms

  • Creating custom code libraries

  • Using add-ins

  • Implementing transactions in your code

For your convenience, I have included the database file and code generated during this chapter for download from Wrox.com.

Get Beginning Access™ 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.