Defaulting number of copies to 3...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I am running an Access report within my Access 2000 app using the
"docmd.OpenReport" syntax. How can I default the number of copies to print
to three instead of one?

Thanks,

Brad
 
I am running an Access report within my Access 2000 app using the
"docmd.OpenReport" syntax. How can I default the number of copies to print
to three instead of one?

Thanks,

Brad
Click to expand...

Basic vanilla method:

DpCmd.OpenReport "ReportName", acViewPreview
DoCmd.PrintOut acPrintAll , , , , InputBox("How Many?","Copies",3)

Add error handling in case the input box is closed or a letter is
entered instead of a number.

The way I would do it, however, is to add an unbound control whose
default value is 3 to the form, and pass it's value to the print out
using (assuming the control is on the same form opening the report:
DoCmd.PrintOut acPrintAll , , , , Me!ControlName
 
Back
Top