Print two report at a time

[CAM]

Hello,

I am using ms access 2003 and I want to print two different reports via a
command button.
The first report is called "Summary" and the second report is called
"Detail"

Cheers

 

[geoleo68]

This is very easy and there are two ways to do it.

1) Create a Macro named mcPrintDetSum in there put an OpenReport command for
each report you want in the order you want it printed out.
Have the button_click sub run a DoCmd.RunMacro mcPrintDetSum

2) Don't create the Macro, simply type in the cmdbutton_click sub
DoCmd.OpenReport "Details"
DoCmd.OpenReport "Summary"
Place them in the order you want them to be printed out.

You can also create filters and additional where clauses from each instance.

geoleo68

 

[CAM]

Thanks for the tip.

This is very easy and there are two ways to do it.

1) Create a Macro named mcPrintDetSum in there put an OpenReport command
for
each report you want in the order you want it printed out.
Have the button_click sub run a DoCmd.RunMacro mcPrintDetSum

2) Don't create the Macro, simply type in the cmdbutton_click sub
DoCmd.OpenReport "Details"
DoCmd.OpenReport "Summary"
Place them in the order you want them to be printed out.

You can also create filters and additional where clauses from each
instance.

geoleo68