Print multiple reports one cmd

  • Thread starter Thread starter David Mainland
  • Start date Start date
D

David Mainland

I use a database at work that allows the printing of
multiple reports from a listing of available reports. The
user can select all or some of the reports to print by
clidking a check box. Can Access 2000 do that, and, if
so, is it difficult to do? Can you print to different
printers to allow for a report and an envelope?
 
Yes to all. Whether it is difficult or not depending on your knowledge of
VBA.

All you need is a Multi-Select ListBox showing the Reports that the user can
select and a CommandButton that has a loop to go through the selected
Reports in the ListBox and open the Reports one at a time.

In the Report Design, you can nominate the specific printer for each Report
as needed.
 
Yes to all. Whether it is difficult or not depending on your
knowledge of VBA.

All you need is a Multi-Select ListBox showing the Reports that the
user can select and a CommandButton that has a loop to go through the
selected Reports in the ListBox and open the Reports one at a time.

In the Report Design, you can nominate the specific printer for each
Report as needed.
Click to expand...
Great information, anybody care to provide an Example of Code for us
novices???

Thank You
 
Hi All: I did this effect but using a macro.
Created a popup form that has check box next to each report choice.
print reports button at bottom.
when you click print report button runs macro containing all reports on form
but with condition set as follows for each report to print:
[Forms]![Work Order Report Choices]![Red1cb]=Yes
where [Red1cb] is the name of the check box next to the report name to print
on form.
dont forget the skipit button at bottom of form to close the popup without
printing reports.
may be the rude way to achieve but works good for me. hope this helps, Ed
 
Back
Top