Auotmatic Macros

  • Thread starter Thread starter BBro
  • Start date Start date
B

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!
 
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.
 
Back
Top