How do I print several different reports with one command?

G

Guest

I have several single page reports I need to print with one command button.
What is the easiest (and most reliable) way to do this?
 
T

Tom Lake

Rocket said:
I have several single page reports I need to print with one command button.
What is the easiest (and most reliable) way to do this?
Click to expand...

Write a macro to print the reports one after the other and execute the macro
from the command button.

Tom Lake
 
K

Keith Wilby

Rocket said:
I have several single page reports I need to print with one command button.
What is the easiest (and most reliable) way to do this?
Click to expand...

DoDmd.OpenReport "rptMyReport1", acViewNormal
DoDmd.OpenReport "rptMyReport2", acViewNormal
DoDmd.OpenReport "rptMyReport3", acViewNormal

etc.

HTH - Keith.
www.keithwilby.com
 

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

Print several reports as one 3
Check the number of pages in a report prior to printing 3
Print a report without displaying print preview 1
Report prints extra page on one computer 3
Print command prints all reports in database? 15
How to print a report with multiple tab controls 1
Pop up before printing report 1
report will not print 2

Top