Multiple Reports; Continuous Page numbers

  • Thread starter Thread starter Greg Ripper
  • Start date Start date
G

Greg Ripper

How do I print, using a macro, several reports in a string and get the page
numbers to start from 1 and end at the end of the last report, somewhere
around 130?

Thanks as Always,

Rip
 
Greg Ripper said:
How do I print, using a macro, several reports in a string and get the page
numbers to start from 1 and end at the end of the last report, somewhere
around 130?
Click to expand...

Create a public (global) variable and in the Print event of each ReportFooter
have code that assigns the value of the last page number to the variable.

MyPageVar = Me.[page]

Then in the Open Event of all reports except the first have code that sets the
[page] value to your variable + 1.

Me.[page] = MyPageVar + 1

Once the [page] property is set on each report upon opening the normal
pagination events will increment it from there.
 
Back
Top