Combining Reports

[NSGuard]

Is there a way to take 11 seperate reports and combine them into one continuous report (the reports each have different fields). report1 followed by report2 and then report3, etc all are apart of reportall.

The program was originally set up to print off all 11 reports, but the user now wants to e-mail all of the reports in one batch aswell instead of just printing each report individually.

Any help or ideas would be appreciated. Thanks.

 

[Darrylles]

Hi,

A simple way would be to have a simple form with a single button that runs each report in turn.

In the <on-click> event of the button; use the following code:

DoCmd.OpenReport report1, acNormal
DoCmd.OpenReport report2, acNormal
DoCmd.OpenReport report3, acNormal
DoCmd.OpenReport report4, acNormal
etc
etc
docmd.close

Hope this helps.

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Darrylles]

NS,

Sorry - I got the wrong end of the stick, but the above code structure would also work by using vba code to mail each report, automatically in turn.
Because of the new security feature introduced by MS however, the user would have to confirm each mail sent.

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.