how can i remove the warnings msgs result from delete and append queries? (1 Viewer)

[pjustin1]

Hi,
I run the delete and append queries from a click of a button, but warning messages(results of delete and append queries) keep popping out.. is there anyway to hide or remove all these...? coz, i don't want to let the user to go through these stages....

btw, i use macro "openquery" to run these queries..

thanks
justin

 

[scottfarcus]

DoCmd.SetWarnings(False)
'Turns Access warnings off

'Run your queries

DoCmd.SetWarnings(True)
'Turns Access warnings back on