Turn off 'You Are About To Update X Rows...'

[MatthewP]

Is it possible to turn off the Access alerts 'You Are About To Update X Rows...' when an update or make table query is run? The guys here keep hitting return instead of clicking yes, and the return sometimes causes a default no to happen - causing all sorts of problems!

Cheers,
Matt.

 

[BillPower]

Docmd.setwarnings False
'Run the Query
Docmd.setwarnings True

Bill

 

[codegirl63]

Matthew,
What you need to do is to turn the warning messages off.
If you are using a macro, you will need to insert a row and select SetWarnings and then the "Warnings On" option to No.
It is a good practice to turn them on again when you have completed your macro.

If you are doing this in VB, you need to use the command
docmd.setwarnings false

To turn the warnings back on at the end of your code, use docmd.setwarnings true.

Hope this helps.