Beginning Access 2002 VBA (Programmer to Programmer)

Overview

The reporting facility is one of the best features of Access, and even though this is a VBA book, there are certain areas of reports that need covering. Reports, just like forms, can have code underneath them, and there are several events that you can use: for example we can code an Open event to raise a message box reminding a user that the report is best run overnight because it takes hours to run. You generally don't need much code on reports, but what little you do use can turn an ordinary report into a great report.

In particular we will be looking at:

• How to use expressions on reports

• Adding totals and summaries

• Events, and which ones to use