View Full Version : how can i remove the warnings msgs result from delete and append queries?


pjustin1
06-03-2002, 08:47 AM
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
06-03-2002, 08:53 AM
DoCmd.SetWarnings(False)
'Turns Access warnings off

'Run your queries

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