running macros automatically

[geek]

how do i let the macros run automatically behind the scene without having to
click "yes" too all the time?

 

[Steve Schapel]

Geek,

Which actions do you have in the macros you are enquiring about?

 

[geek]

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?

 

[Steve Schapel]

Geek,

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

 

[geek]

yeap! thanks for your help! my problems are all gone! =D