Is it possible to bypass all the Dialog Boxes when running a macro?

[markvan]

I have set up a series of queries that are activated by a macro, which works like magic, BUT.....
You have to click YES YES YES YES YES YES YES about a dozen times. Is it possible to automate the "Yes"s and get rid of all these confirmation screens?

Mark Van Laarhoven
Dot Imaging Online Printers, Sydney, Australia.

http://www.dotimaging.com.au

 

[markvan]

Problem solved

I used this code:

Private Sub btn_SendActivityReport_Click()
On Error GoTo Err_btn_SendActivityReport_Click
DoCmd.SetWarnings False
Dim stDocName As String

stDocName = "Macro_Send_Activity_Report"
DoCmd.RunMacro stDocName
DoCmd.SetWarnings True
Exit_btn_SendActivityReport_Click:
Exit Sub

Err_btn_SendActivityReport_Click:
MsgBox Err.Description
Resume Exit_btn_SendActivityReport_Click

End Sub


Mark Van Laarhoven
Dot Imaging Online Printers, Sydney, Australia.

http://www.dotimaging.com.au