Printing

J

jeff

I have some reports that I would like to print but will like to have more
than just one copy at a time. I would like to print 4 ea.
How can I code it so I can have the option of printing more than just one
file.

Jeff

--
 
F

fredg

I have some reports that I would like to print but will like to have more
than just one copy at a time. I would like to print 4 ea.
How can I code it so I can have the option of printing more than just one
file.

Jeff

Here is one method.
DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.SelectObject acReport, "ReportName", False
DoCmd.PrintOut acPrintAll, , , , InputBox("How Many copies?", ,1)

It would be better however to have the number of copies wanted entered
into an unbound control on the form, in which case, use:

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.SelectObject acReport, "ReportName",True
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

Top