macro to print multiple reports

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
 
S

Steve Schapel

Bigred,

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

- Steve Schapel, Microsoft Access MVP
 
B

_Bigred

Thank you for the quick answer. Is there a way to run the macro without it
being seen on the screen?

TIA,
_Bigred
 
S

Steve Schapel

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
 
B

_Bigred

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

Weekly Report 2
Report Group Footer DLookUp 0
VBA word change keys 0
Macro to search for a value on multiple tabs 0
Print order of TriFold - Publisher 365 0
Setting language of a selected text in Office apps. 0
printing (quantity)? 0
it's late (or i'm losing my mind) 3

Top