O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required