Article ID: 154894 - View products that this article applies to.
This article was previously published under Q154894
Moderate: Requires basic macro, coding, and interoperability skills.
This article describes how to add a record to a table each time that you print a report. This technique is useful for maintaining a print log that tracks the print history of a report.
The following example uses the Print event of a report to add a record to a table. The record contains the report's name and print date. The example uses the report's Activate and Deactivate events to set a global variable that is evaluated during the Print event. This prevents Print Preview from adding a new record to the history table.
NOTE: In Microsoft Access 7.0 and 97, there is one sequence of events that will create a new record in the history table when you Print Preview the report. If you open the report in Design view to view or change any of its code and then switch to Print Preview, the Activate event does not occur, and the global variable is not set. To work around this problem, after viewing or changing the report's code, close the report before you open it in Print Preview.
CAUTION: Following the steps in this example will modify the sample database Northwind.mdb (or NWIND.MDB in version 2.0 or earlier). You may want to back up the Northwind.mdb (or NWIND.MDB) file and perform these steps on a copy of the database.
Creating a History Table and a Report
Generating a History Record
For more information about Activate and Deactivate events, search the Help Index for "Activate," or ask the Microsoft Access 97 Office Assistant.
For more information about Print events, search the Help Index for "Print Event," or ask the Microsoft Access 97 Office Assistant.
Article ID: 154894 - Last Review: January 19, 2007 - Revision: 2.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Contact us for more help