Help!

Access macro- how automatically run without clicking yes t..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  loop through records on a list box and group  
Author Message
Need2know
External


Since: Mar 16, 2007
Posts: 2



PostPosted: Tue Mar 20, 2007 10:30 am    Post subject: Access macro- how automatically run without clicking yes to each s
Archived from groups: microsoft>public>access (more info?)

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?
Back to top
Kelvin Beaton
External


Since: Jan 22, 2004
Posts: 108



PostPosted: Tue Mar 20, 2007 12:40 pm    Post subject: Re: Access macro- how automatically run without clicking yes to each s [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


"Need2know" wrote in message

> 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?
Back to top
Kelvin Beaton
External


Since: Jan 22, 2004
Posts: 108



PostPosted: Tue Mar 20, 2007 1:12 pm    Post subject: Re: Access macro- how automatically run without clicking yes to each s [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I guess I said that wrong.

Set them to "No"

Sorry about that

"Kelvin Beaton" <kelvin at mccsa dot com> wrote in message

> In your macro, under Actions choose SetWarnings to "yes"
>
>
> "Need2know" wrote in message
>
>> 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?
>
>
Back to top
John W. Vinson
External


Since: Jan 29, 2004
Posts: 2693



PostPosted: Tue Mar 20, 2007 3:10 pm    Post subject: Re: Access macro- how automatically run without clicking yes to each s [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Tue, 20 Mar 2007 08:40:25 -0500, "Kelvin Beaton" <kelvin at mccsa dot com>
wrote:

>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]
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum