Help with queries please.....

[vince99]

Is there a way to automaticly answer yes when you run a query without actually having to hit the yes box on the pop-up box?

Thanks in advanced

 

[JerryDennison]

I'm going to asssume you're running an update, append, or delete query(since these are the only ones that ask for confirmation). If you're running the query from code, you can turn warnings off and then back on.

...
DoCmd.SetWarnings = False
DoCmd.OpenQuery("queryname&quot
DoCmd.SetWarnings = True
...

 

[TheInsider]

You can also turn the warning messages off permanently by going to the Tools menu / Options / Edit/Find tab and unchecking Confirm "Record Changes", "Document Deletions", and "Action Queries". Rob Marriott
rob@career-connections.net