Doh!

[Steve Bremner]

Hi Guys! I have totally forgotten when running a query how to stop it asking for confirmation before it runs!!

IT'S DRIVING ME MENTAL!! Any ideas?

 

[crosmill]

setwarnings false

hth

 

[Steve Bremner]

Thanks! To make matters worse however, I can't remember where to edit it!
It's been a while since I used Access!

 

[crosmill]

you need to code it into the VBA, I'm not sure if there is a menu option that will turn it off?


If you right click the button that runs the query, build event then code. and put the line in after the sub and before any other code.

don't forget to turn them back on again before end sub

setwarnigs true

 

[Steve Bremner]

There is a menu option somewhere but I can't remember where! Thanks for refreshing the memory, I'll just manually set it.
If anyone can remember please post cos It's driving me nuts!

 

[Steve Bremner]

WOO HOO!

Not idea but better than a kick in the nuts!
Check this thread