Batch Print Reports

  • Thread starter Thread starter nhdee
  • Start date Start date
N

nhdee

I have a Macro set to run all the reports I want and that works BUT it
prompts me to press OK (print dialog box) for each report. Is there anyway
to avoid that and just have it prompt once and print all reports?
 
nhdee,

What is the Access version and macro actions?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a Macro set to run all the reports I want and that works BUT it
prompts me to press OK (print dialog box) for each report. Is there anyway
to avoid that and just have it prompt once and print all reports?
 
Access 2007;
OpenReport; Property Report, (Normal)
Run Command; Print

Repeat above for each of the reports (12 +/-) want to print.
 
Answered my own question but I am posting what I did in case any one else
wants the answer for Access 2007: I created a macro with Action: Open Report,
for each of the reports I want to print, and for arguments VIEW is set to
PRINT! That's the trick. Once I changed view to print rather than report it
prints all my reports and does NOT display them on the screen. Hope this
helps someone else!
 
Back
Top