Permission Windows

[access_challenged]

Is there a setting that allows me to run a query without having to click yes
after each step? I have 11 steps and I spend so much time accepting every
step that it takes forever! Thanks.

[rquintal@sympatico.ca]

Re: Permission Windows

On Mar 26, 12:15 pm, "access_challen ged" <u42441@uwewrot e:

Is there a setting that allows me to run a query without having to click yes
after each step?  I have 11 steps and I spend so much time accepting every
step that it takes forever!  Thanks.

I've told you a million times not to exaggerate.

Untick the box at Tools->Options->Edit/Find->Confirm->Record Changes.

Be aware that those confirmation notices are good insurance.

You may want to encapsulate the entire process into a macro that does
SetWarnings Off
Openquery "myQueryNam e"
SetWarnings Off


Q

[access_challenged]

Re: Permission Windows

rquintal@sympat ico.ca wrote:

>Is there a setting that allows me to run a query without having to click yes
>after each step?  I have 11 steps and I spend so much time accepting every
>step that it takes forever!  Thanks.

>
>I've told you a million times not to exaggerate.
>
>Untick the box at Tools->Options->Edit/Find->Confirm->Record Changes.
>
>Be aware that those confirmation notices are good insurance.
>
>You may want to encapsulate the entire process into a macro that does
>SetWarnings Off
>Openquery "myQueryNam e"
>SetWarnings Off
>
>Q

Oddly enough, that didn't work.. Any other ideas?

[Ron2006]

Re: Permission Windows

try False instead of OFF


it can also be issued as

docmd.setwarnin gs false


Ron