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