Page numbers on a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to run a loop on a report so it prints the same report a specified number of times....also when it does this is there a way to put the page numbers on the report so it appears as "1 of 3" and the next page "2 of 3" etc......
 
First Question:
If you print manually: don't use the Print button on the toolbar, go from
the menu. The Print window that opens lets you specify the number of copies.
If you print from a macro: type the number of copies you want in the Copies
argument of the PrintOut action.
If you print from a module: again, one of the arguments of the PrintOut
method is number of copies, e.g. 5 below:
DoCmd.PrintOut acPrintAll, , , acHigh, 5, False

Second question:
Access puts that in the page footer of a report by default, if you use the
report wizard to make it. If not, in the report footer create a text box and
in the control source property put:
="Page " & [Page] & " of " & [Pages]

HTH,
Nikos

brimil said:
Is it possible to run a loop on a report so it prints the same report a
Click to expand...
specified number of times....also when it does this is there a way to put
the page numbers on the report so it appears as "1 of 3" and the next page
"2 of 3" etc......
 
First Question:
If you print manually: don't use the Print button on the toolbar, go from
the menu. The Print window that opens lets you specify the number of copies.
If you print from a macro: type the number of copies you want in the Copies
argument of the PrintOut action.
If you print from a module: again, one of the arguments of the PrintOut
method is number of copies, e.g. 5 below:
DoCmd.PrintOut acPrintAll, , , acHigh, 5, False

Second question:
Access puts that in the page footer of a report by default, if you use the
report wizard to make it. If not, in the report footer create a text box and
in the control source property put:
="Page " & [Page] & " of " & [Pages]

HTH,
Nikos

brimil said:
Is it possible to run a loop on a report so it prints the same report a
Click to expand...
specified number of times....also when it does this is there a way to put
the page numbers on the report so it appears as "1 of 3" and the next page
"2 of 3" etc......
 
Back
Top