running macros automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i let the macros run automatically behind the scene without having to
click "yes" too all the time?
 
I have open queries in my macros such as append and delete queries. whenever
the user press the button on "update" they will have to press "yes" to the
messages that popped out from "Are you sure you want to run this type of
query?" how to run these macros without the using clicking "yes" for quite a
number of times?
 
Geek,

Put a SetWarnings/No action in your macro before the first of the
OpenQuery actions.
 
Back
Top