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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Need2know - 20 Mar 2007 14:30 GMT

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?

Reply to this Message

Kelvin Beaton - 20 Mar 2007 14:40 GMT

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

> 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?

Reply to this Message

Kelvin Beaton - 20 Mar 2007 15:11 GMT

I guess I said that wrong.

Set them to "No"

Sorry about that

> In your macro, under Actions choose SetWarnings to "yes"
>
[quoted text clipped - 5 lines]
>> way
>> through by itself?

Reply to this Message

John W. Vinson - 20 Mar 2007 18:10 GMT

>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]

Reply to this Message