Picking and choosing what reports to print from a list.

  • Thread starter Thread starter Srowe
  • Start date Start date
S

Srowe

I want to be able to have a list of all of my reports on one form and have
the user be able to choose which one (s) they would like to print. It would
be based on a query of what file number the reports are to come from.

Thanks.
 
On Mon, 17 Nov 2008 18:58:01 -0800, Srowe

One option is to have a multi-select listbox and set its rowsource to
a query on the system table MSysObjects.
Then write some VBA code to loop over the selected items and call each
report in sequence, with the WhereClause argument set to the file
number you want to run it for.

I would be surprised if ALL your reports would be about file numbers.

-Tom.
Microsoft Access MVP
 
You must log in or register to reply here.

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

Print a report from a form where you choose parameters 4
printing 1 sheet of report 1
Convert to .pdf and print 5
How to Print a Subreport from a filtered search 1
Print a Report to PDF 3
Access Access Report Works on One Machine but not Another 3
Report list in a drop-down box 8
Printing a report 2

Back
Top