Run an update query without the pop up prompts

[Mr. SLP]

I’ve got a query that I want to be ran after a report is generated and emailed to indicate that all the records on the report have been submitted. I have an update query that does the job great but i can’t figure out how to keep all the pop up confirmations showing before the query will run. Any tips/advice?


Sent from my iPhone using Tapatalk

 

[pbaldy]

Does this help?

http://www.baldyweb.com/SQLWarnings.htm

 

[plog]

File -> Options

Client Settings

Confirm -> Uncheck all 3 options

 

[pbaldy]

Be aware that while plog's suggestion will work, it is an Access setting on the computer. In a multiuser environment, other users will still see warnings unless they also change their settings. I prefer to control it from within the db.

 

[Mr. SLP]

Does this help?

http://www.baldyweb.com/SQLWarnings.htm

That was exactly what I was looking for. Thanks.


Sent from my iPhone using Tapatalk

 

[pbaldy]

Happy to help.