I HAVE A REPORT THAT IS BEING GENERATED FROM A QUERY, AND WHAT I NEED TO DO IS HAVE IT AUTOMATICLY PRINT OUT 4 COPIES, I HAVE NCR PAPER AND I NEED FOUR COPYS OF THE SAME REPORT RIGHT NOW WE ARE HITTING THE PRINT BUTTON 4 TIMES ANY HELP WOULD BE GREAT THANKS
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MANNY COPIES OF ONE REPORT
- Thread starter hartbros
- Start date
Here's one way to do it. Open the report in preview, print it and then close it.
DoCmd.OpenReport YourReport, acPreview
DoCmd.PrintOut , , , ,4
DoCmd.Close
Unfortunately the DoCmd.OpenReport doesn't seem to have a copies option. The Close command can be left out if you want to see it in Print Preview.
John Green
DoCmd.OpenReport YourReport, acPreview
DoCmd.PrintOut , , , ,4
DoCmd.Close
Unfortunately the DoCmd.OpenReport doesn't seem to have a copies option. The Close command can be left out if you want to see it in Print Preview.
John Green
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question