print more than one report on macro

[AWilderbeast]

hi im trying to print multiple reports using one macro, i cant seem to find anything to make it print one report never mind multiple, any ideas or suggestion mroe than welcome thanks

 

[marystewart78]

Hi,

New to Access so there may be a better way to do this but how I would do it is to - in the action section of the macro choose openReport and in the bottom of the screen Action Arguments chose View| Print. Repeat this for as many reports as you wish to open - each on a new action line. And you will be able to print many reports automatically on one macro.

Hope this helps.

Mary

 

[halem2]

you can paste this Access generated code (with small modifications - just added more reports) on the OnCLick event of the button you're using to print the reports.

Just replace the "Report 1 Name" (and 2 and 3) with your reports names and replace the "Button_Name_Here" with the name of the button.

On Error GoTo Err_Button_Name_Here_Click

Dim stDocName As String

stDocName = "Report 1 Name"
DoCmd.OpenReport stDocName, acNormal

stDocName = "Report 2 Name"
DoCmd.OpenReport stDocName, acNormal

stDocName = "Report 3 Name"
DoCmd.OpenReport stDocName, acNormal

Exit_Button_Name_Here_Click:
Exit Sub

Err_Button_Name_Here_Click:
MsgBox Err.Description
Resume Exit_Button_Name_Here_Click