Different reports open in same window

[detjo]

Hi All

On a form I have a button that runs a macro. The macro opens 15 different reports, but the only way i could get it to work was to have each report open in its own window (up to 15 report windows stacked on top of each other!).
The problem with this is, if they need printing, each report is sent to the printer as a single page - so the printer lists all 15 reports as a separate print job meaning each 'job' has to be released instead of just one job printing all 15 pages. Sooo much slower and a PITA



Is there a way to get all 15 reports to open in the same window?

- Each of the 15 reports has its own report template as they are all different
- It would be better for me if this could be done in a macro as i know nothing about VBA
- If it has to be done in VBA i'm willing to give it a go, but i'll prob need comments included so i can see exactly what is doing what etc.

I appreciate yur time and help and thanks in advance!

- - - - - - - - - - - - -

detjo

[June7]

As far as I know each report is distinct and can't 'share' window. Might be able to code a custom 'Print All' button that would print all open reports. This is customization of ribbon and QAT (quick access toolbar). When I did button/ribbon customization in a 2007 project, required HTML code in a special table called USysRibbons. If you are still interested, check out http://forums.aspfree.com/microsoft-...at-303789.html

Alternatively, send reports direct to printer.