Use Automation to Print 2 or 3 Reports at a time

[Dee]

Hi all!

I would like to programtically print multiple reports at a
time or sequentially. I have 3 or more reports to print
monthly on 30 reps (individually). What I would like to
is create a macro or somehow programatically in VBA be
able to print those reports sequentially. After one
starts, it goes to the next and the next and so on.

I have found 2 articles in the Microsoft Knowledge Base.
One shows how to use automation to collate and print
multiple reports, but I don't need the collation feature
and the code seems to be so explicit that I can't figure
out how to use that code without the collation feature.
the other is Article #145707 and shows how to print a
specific report with specific parameters. My reports have
me enter a Rep Code each time it opens, so that I can
specify for whom I want to run the report.

Anyone know the code or how to do this?

If you need more detailed info, please let me know....

Dee

 

[Rick Brandt]

Hi all!

I would like to programtically print multiple reports at a
time or sequentially. I have 3 or more reports to print
monthly on 30 reps (individually). What I would like to
is create a macro or somehow programatically in VBA be
able to print those reports sequentially. After one
starts, it goes to the next and the next and so on.

I have found 2 articles in the Microsoft Knowledge Base.
One shows how to use automation to collate and print
multiple reports, but I don't need the collation feature
and the code seems to be so explicit that I can't figure
out how to use that code without the collation feature.
the other is Article #145707 and shows how to print a
specific report with specific parameters. My reports have
me enter a Rep Code each time it opens, so that I can
specify for whom I want to run the report.

Are you running this from outside of Access (like in a VB app). If not Automation
doesn't really enter into it. Just drop a button on a form and use the wizard to
print one of the reports you want. Then examine the code in the OnClick event for
that button. Find the line that starts. . .

DoCmd.OpenReport ...

.. . .and copy it for as many reports as you want to print changing the name of the
report on each new line.

 

[Dee]

Thanks! I wish everyone was as nice when they write you back on here...
I'll be in touch!

Dee