Defaulting number of copies to 3...

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
 
F

fredg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting the "number of copies" in code for an access report 2
Syntax for number of copies to print? 1
Multiple copies of Report 5
Number of copies 3
Setting print properties from an Access 2000 app.. 1
Printing copies of report without opening it 5
Help - Loop within a loop code 3
3 part form using plain paper 2

Top