Solved: Running all the report in a DB

[lostin_space]

Hi all, i've got a small access database that has about 10 - 15 1 page reports within it... i'm an access newbie (excel + vba are 'my thing' normally) and i'd liek to be able to run all the reports in 1 hit...

can anyone give me an idea of how i could do this please?:dunno

[OBP]

You can do it in 2 ways, using a Macro or using VBA. Both are easy enough to do, with the macro in design view choose Run Report from the "Action" Drop Down list and then select the report fro the list at the botom of the screen. Do this for each report, all in one macro.
To use VBA, use the "Toolbox Wizard" to create a command button on a form in design view and select "Reports" under the operation, the select the report from the list.
Once you have this, switch to the VB Editor view and copy the code once for each report and change the name in the inverted commas.

[lostin_space]

sorted! many thanks!