Chapter 5. Building Procedures

IN THIS CHAPTER

Types of Procedures 67

Passing Arguments 71

Error Handling 73

Types of Procedures

The basic containers for your VBA code are procedures, which hold collections of VBA code statements that are executed line by line. Although individual statements can be executed from the Immediate window of the VBE, you must place your code into procedures to run the statements from your applications. Your procedures are placed into modules, which can be attached to a form or a report object, or they can stand alone. We’ve shown you some short procedures in previous chapters, but this chapter goes into creating and using procedures in more depth.

The first thing to understand is that there are two main kinds of procedures: ...

Get Microsoft® Office 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.