Business solutions Automating Microsoft

14. Working with Reports

IN THIS CHAPTER

Introducing the Report Module and Events

Opening and Closing Reports

Passing Arguments Using OpenArgs

Populating the Report

Handling Report-Level Errors

Using VBA to Determine Group Properties

Introducing the Report Module and Events

For the most part, VBA code is stored in one of two module types: standard or object. The object module is a special module attached to a report or a form. The module is saved with the object and supports events and properties that are unique to the object.

Most of the code you enter and store in a report module (or a form module for that matter) comes in the form of event procedures—code that’s executed when some action occurs. For instance, code added to the report’s ...