Action Query Messages

[PGL]

Hi,

I have a huge database with many Action Queries. I cannot "hide" the Action Query Messages like SetWarnings previously. My setting in properties is not active. See pic..........

Tx

 

[Galaxiom]

Turning off warnings isn't such a good idea anyway because all errors are silently ignored.

Better to use Currentdb.Execute to run the query. Include the second argument with the value dbFailOnError. This only triggers errors on actual failure

 

[PGL]

Tx, but is still funny that the de activated choice remains the same as the activated choice.

Can you perhaps send me an example of where and how to use Currentdb.Execute and dbFailOnError please?

Appreciate Tx

 

[jdraw]

Try Google or Bing with
msaccess currentdb.execute dbfailonerror
Good luck.