macro to print multiple reports

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

(Access 2000)

Is there a way to setup a macro to print multiple reports (with the click of
one macro - button)?


TIA,
_Bigred
 
Bigred,

Yes, a macro with a series of OpenReport actions, one for each report.

- Steve Schapel, Microsoft Access MVP
 
Thank you for the quick answer. Is there a way to run the macro without it
being seen on the screen?

TIA,
_Bigred
 
Bigred,

Without what being seen on the screen? You mean the reports? The
View argument of an OpenReport macro is Print, which means it will go
straight to the printer. Have you got yours set to Preview?

- Steve Schapel, Microsoft Access MVP
 
oh that was easy enough. Thanks for the answer Steve, I had it set to
preview.


Thanks again,
_Bigred
 

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

msgbox macro 1
auto run macro if 1st mon of month 6
timer/date event set to print on 1st mon of month 7
autorun a macro (on 1st mon of every month) 1
Type Mismatch with Option Group 1
Using macro to delete value from a specific field in multiple reco 1
Sending multiple reports with same parameters 1
Printing from a macro 1

Back
Top