Counting # of pages printed from a report

[Kazoo]

I'm trying to capture the # of pages printed from a report to use on another report.

There are several records that are not standard size, therefore I can't just count the records and deduce how many pages printed.

Anyone have any ideas?

[lee123]

you mean like on the page footer if so enter this

="Page " & [Page] & " of " & [Pages]

i think this will help.

lee123

[Kazoo]

you mean like on the page footer if so enter this

="Page " & [Page] & " of " & [Pages]

i think this will help.

lee123

Thanks for your suggestion, but no, not on the page footer and actually not even on the same report. I want to post the total pages on a different report.

[Scott Price]

You'll need to place a hidden text box on the report with its control source set to

=Pages

Then create a Public variable in a standard code module, not in the report's code module, call it intTotalpages or whatever you like. Next you can populate this variable in the OnPage event of your report. Since it's declared as Public, it will be available until you close the database or change it.

If you need it to be available beyond a close/reopen, you'll need to write it to a table set to hold just this data.

Regards,
Scott

[Kazoo]

You'll need to place a hidden text box on the report with its control source set to

=Pages

Then create a Public variable in a standard code module, not in the report's code module, call it intTotalpages or whatever you like. Next you can populate this variable in the OnPage event of your report. Since it's declared as Public, it will be available until you close the database or change it.

If you need it to be available beyond a close/reopen, you'll need to write it to a table set to hold just this data.

Regards,
Scott

Thank Scott. That sounds like it will work perfectly.

[Scott Price]

Glad to be of a help! Let me know if there's anything more that you need to get this working.

You might need to declare this variable as a Static variable instead of just a Public. The Static has a greater scope, meaning it lasts longer than the Public. However, not even a Static will hold it's value through a close/reopen of the database.

Regards,
Scott