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

[Guest]

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?

 

[Kelvin Beaton]

In your macro, under Actions choose SetWarnings to "yes"

 

[Kelvin Beaton]

I guess I said that wrong.

Set them to "No"

Sorry about that

 

[John W. Vinson]

In your macro, under Actions choose SetWarnings to "yes"

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]