reports

F

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
 
F

fredg

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
 
Top