Printing Multiple Reports

[Guest]

I am seeking to print multiple reports with one click . Currently I can only
pull one report at a time. When I try to enter multiple values the reports
are not available. I currently have a combo box and I have the Row Source
Type listed as a "Value List". I have tried using the semicolon, but it still
will not print the multiple reports. It does print a single report at a time
without problem; however, I have many reports to print and I would love to
just copy and paste a list from Excel into the combo box. I can easily add
the semicolons between report names in Excel, so this is not the issue. In
the future I would also like to be able to export all of these individual
reports to disk with one button. Any suggestions would be appreciated. Also,
my VB skills are limited, but I can figure it out with help.

 

[John Vinson]

I am seeking to print multiple reports with one click . Currently I can only
pull one report at a time. When I try to enter multiple values the reports
are not available. I currently have a combo box and I have the Row Source
Type listed as a "Value List". I have tried using the semicolon, but it still
will not print the multiple reports. It does print a single report at a time
without problem; however, I have many reports to print and I would love to
just copy and paste a list from Excel into the combo box. I can easily add
the semicolons between report names in Excel, so this is not the issue. In
the future I would also like to be able to export all of these individual
reports to disk with one button. Any suggestions would be appreciated. Also,
my VB skills are limited, but I can figure it out with help.

A combo box has *only one value* - the one you select. You can't base
a report on the list of values in a combo box! Semicolons won't help
either.

What you *can* do, however, is have a (temporary, or linked Excel)
Table with a list of all of the ID's for which you want to run
reports. Base your Report on a Query joining this table, rather than
using a criterion to pick a single value. You may need to change the
Sorting and Grouping property of the Report to print each "report" on
its own page.


John W. Vinson[MVP]