counting printouts

[ferhanz]

Is there a way we can count how many times a report is printed and display the count result on the report. I want this because my office wants to know that once the Purchase Order is printed it should not be printed again and if it printed it should show the print count so that an explanation can be given on why the report was printed again


thankyou


Farhan

 

[John Big Booty]

You'll need to add a field to one of your tables that gets updated (+1) each time the print report code is fired. This field would default to Zero and the update would be the first part of the code that prints the report. This field would be picked up by the query that populates your report.

 

[ferhanz]

What will be the code i have to put on the Print Record button ?

 

[John Big Booty]

Assuming that your Print Report Button is on a form which contains data that will be part of the report, it will look something like;

Me.PrintCount = Me.PrintCount + 1
DoCmd.OpenReport Rpt_Name, acNormal