Access macro- how automatically run without clicking yes to each s

N

Need2know

I'm running a macro which contains several sub-macros. I have to manaully
click "yes" for every qusetion it asks for each step. Is there a way to have
it automatically answer yes to each step so the macro will run all the way
through by itself?
 
J

John W. Vinson

In your macro, under Actions choose SetWarnings to "yes"
Click to expand...

As Kelvin corrected himself, that should be No. BUT... Just be sure to ALSO
put a line setting SetWarnings back to Yes after the last step of the macro;
otherwise you'll turn off all warnings and confirmations for the rest of the
Access session.

John W. Vinson [MVP]
 
Top