Print without Previewing: Please help

D

dollachart

Thanks for the help in advance. I have 5 different reports that makes
up a contractual package. I already setup each one to be able to
preview but I want to make a button to print all of these 5 reports
without previewing. They should go straight to the default printer even
without the print dialog box pops up. I already tried something like
rptPart1.Print but that didn't work. Please suggest.
Thanks again.
DK
 
F

fredg

Thanks for the help in advance. I have 5 different reports that makes
up a contractual package. I already setup each one to be able to
preview but I want to make a button to print all of these 5 reports
without previewing. They should go straight to the default printer even
without the print dialog box pops up. I already tried something like
rptPart1.Print but that didn't work. Please suggest.
Thanks again.
DK

Code the click event of a command button:

DoCmd.OpenReport "Report1"
DoCmd.OpenReport "Report2"
DoCmd.OpenReport "Report3"
DoCmd.OpenReport "Report4"
DoCmd.OpenReport "Report5"
 
D

dollachart

fredg,
Thanks a lot. I've been using DoCmd.OpenReport with Preview Option for
years but didn't know I can use without it and it prints out right
away. Silly me. Thank you so much.
DK
 

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