VBA Print Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a set of reports unique to several different facility types. Each
report is a component of "The Overall Report". each report also lists the
facilities by ascending Map ID order. So what i end up with is something like
this; the CarWash report contains MapID's 1, 5 & 7. The Cemetery report
contains MapID's 2, 3, 4 & 6. I was wondering how i could print these reports
by MapID order using vba to loop through all reports in order to find MapID 1
and print that page, then look for MapID 2 and print that page and so on.
Thanks in advance
 
Hi Kevin,

If the MapID is unique then, in the Sorting and Grouping options sort on
MapID. No VBA required.

HTH
 
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

Report duplicates 0
Printing a report 2
Problems printing reports in 2003 MS Access 1
Access report preview and print only the first page 2
How to sort records in a report 4
Required to Print 2 Copies of Specific Report 2
Problems generating reports from a modal dialog 3
Images issues with Access 2007 9

Back
Top