No Warnings For Insert

[jwlnewsome]

when i use an INSERT Sql function to update my database i get a popup warning telling me " You are about to append 1 row(s)".

Is there a way of bypassing this warning so the database is just updated no fuss ?
thanks in advance
john

 

[reclusivemonkey]

Tools --> Options --> Edit/Find

In the "Confirm" section, Untick "Action Queries". That should do the trick.

 

[jwlnewsome]

cheers mate nice one
john

 

[ghudson]

Depending on the security and usage of the db you might considering turning the warnings off only when needed.

DoCmd.SetWarnings False
'your action queries run here
DoCmd.SetWarnings True

 

[jwlnewsome]

Thanks to everyone

john