Chapter 26. Writing Visual Basic for Applications Code

In this chapter

Understanding the Role of VBA in Access

Introducing VBA 6.0

Where You Use VBA Code

Typographic and Naming Conventions Used for VBA

Modules, Functions, and Subprocedures

References to VBA and Access Modules

Data Types and Database Objects in VBA

Symbolic Constants

Controlling Program Flow

Handling Runtime Errors

Exploring the VBA Editor

Examining the Utility Functions Module

Printing to the Immediate Window with the Debug Object

In the Real World—Macro Schizophrenia