Auotmatic Macros

[BBro]

I have created some macros that delete records based on a
criteria. For example, when my macro runs it indicates
the number of records to be deleted for each openquery
referenced and then I have to confirm by clicking yes.

Is there a way to eliminate user intervention completely
when running macros in access?

Thanks!

 

[Ken Snell]

You can turn off this "alert message box" by putting a SetWarnings action in
the macro before you do the OpenQuery action. Set the argument of the
SetWarnings action to No to turn them off; use an argument of Yes to turn
the messages back on.