Removing Warning Messages from Queries

[Moxioron]

Hello.

I have two update queries and one append query that I would like to disable the warning messages that pop up.

Can that be done?

Thanks for your help.

 

[jackd]

How are you invoking/executing these queries?

In vba you can use
db.execute ActionQueryName,dbFailOnError

You can also turn off warning messages --- not advised/ not recommended by using

docmd.setwarnings False

see http://msdn.microsoft.com/en-us/library/aa220747(v=office.11).aspx

 

[Montez659]

Removed...

Um, yeah, what Jackd said

 

[Moxioron]

I have them in a macro with a couple of other Actions.

Thanks for your response.

 

[Moxioron]

docmd.setwarnings False

Worked. Thanks.

The reason why I am disabling them is because I have some other message boxes that are a little more user friendly and not so confusing for the users.