Special Edition Using Microsoft® Access 2000

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

Understanding the Role of VBA in Access

Historically, productivity applications, such as the members of Microsoft Office, have used macros (short for macroinstructions) to automate repetitive operations. Microsoft Word and Excel, ...