Report Printing

[Kat]

I have several reports I re-create every month with sales figures of all our
customers. I have a total of 28 reports that need to be printed. My
question is... Is there a way to set up a print command or button that I
can click once and all reports would be sent to the printer. It's such a
pain to highlight the report and click print, then highlight the next and
click print and so on. How would I set this up and if I have to type code,
what do I have to type and where? My reports are named, Report1 Report2
Report3 etc

Thanks


Kathy

 

[Van T. Dinh]

You can use a set of 28 commands in a procedure:

DoCmd.OpenReport "Report1", ...
DoEvents
DoCmd.OpenReport "Report2", ...
DoEvents
.....
DoCmd.OpenReport "Report28", ...
DoEvents

Use error-trapping in your code also ...

 

[Guest]

and while the purists stick strickly with vba code and don't bother with
macros - what you request is easily implemented as a vanilla embedded feature
within the macro feature set too.

then you can set your command button to implement the macro...

 

[Kat]

Thanks, that worked like a charm!!! I put the macro together and then just
ran it... it will save me time next month when I don't have to re-create
the macro... woo hoo... Thanks!!

Kathy