reports

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

Guest

is there a way (well, i know there's a way) to input the number of copies to
be printed for a report w/out going into print properties at print time?

thank you,
//frank
 
is there a way (well, i know there's a way) to input the number of copies to
be printed for a report w/out going into print properties at print time?

thank you,
//frank
Click to expand...

Look up the PrintOut method in VBA help.
The number of copies to print is one of the arguments.

You can set the value to a user entered value in a control on a form
if you wish or hard code it.
The below code will print 3 copies of a report that is NOT already
open.

DoCmd.SelectObject acReport, "ReportName", False
DoCmd.PrintOut acPrintAll, , , , 3
 
Back
Top