PrintingSpecificReports.mdb (expert)

Please consider donating $1 per sample downloaded, find out why here
Access 97 (26 KB)

This illustrates how to print the same report multiple times with different data. The tblParameters table holds the the criteria on which the report is based. In this case it is just one criteria [Acct] = whatever is in the Param field.

Method 1 (Module1) goes through the tblParameters table one record at a time and re-creates the query on which the report is based. Then prints the report the number of times as indicated in the tblParameters table. If there is no data in the report, it aborts the printing. (See the report's OnNoData event.)

Method 2 (Module2) uses the same parameter table, but uses the WHERE condition of the OpenReport method to restrict the records shown in the report.




Need Winzip?

Return to Main Page