Total number of printing reports

K

KarenY

I want to record the total times of printing a report, the same report is
printed after updating/editing/adding with more records. I have tried the
tip from Allen Browne's website about the "numbering entries in a Report" of
which I thought that would be the one I needed. However, it doesn't work, no
matter how many times I print the Report, the "1" is always printed, it
doesn't print 2, or more....
Control Source =1
Running Sum Over Group

I think I must have misunderstood Allen Browne's tip, will anybody please
help? Access 2000.
thanks
Karen
 
R

Rick B

I think you are missing what Allen's code does. That code is used to assign
a line number to each item on the report. You say that you want to count
the number of times a report is printed. To do that, you'd need to write
some code that updates a number somewhere each time the report is opened or
closed.
 
K

KarenY

Thank, Rick, I thought so.
What kind of codes you mean to write ? I don't know much about vba. Please
write it out for me to see if I can follow. I mean after printing, not open.
Is it possible ?

Karen
 
R

Rick B

I don't know exactly what code you'd write. You'd need to have a field in a
table somewhere that stores "TimesPrinted". You could do this for each
report or just one. Your table structure would need to include the report
name if you want to store more than one.

Then, write code to grab that field, add one to it, and post it back. I
don't have any examples handy that do this. You might look at some of the
previous posts that discuss how to increment a field by one.

You'd tie this code to one of the events in your report. I don't see an
event that fires when the report goes to the printer. You'd either have to
do it on "open" or "close".

Good Luck.
 
K

KarenY

I think I know what you mean. thank you.

Karen

Rick B said:
I don't know exactly what code you'd write. You'd need to have a field in a
table somewhere that stores "TimesPrinted". You could do this for each
report or just one. Your table structure would need to include the report
name if you want to store more than one.

Then, write code to grab that field, add one to it, and post it back. I
don't have any examples handy that do this. You might look at some of the
previous posts that discuss how to increment a field by one.

You'd tie this code to one of the events in your report. I don't see an
event that fires when the report goes to the printer. You'd either have to
do it on "open" or "close".

Good Luck.
Click to expand...
 
Top