Suppressing warning messages from MakeTable query

J

John S. Ford, MD

I have a command button on a form than executes a MakeTable query using the
DoCmd.RunSQL method based on entered criteria. It works fine but creates a
table deletion warning and an "about to paste records" warning that I'd like
to supress because they're superfluous.

How can I do this? Can it be done without supressing other important
warning messages elsewhere?

John
 
L

Lord Kelvan

docmd.SetWarnings = False
'your code
docmd.SetWarnings = true

remember to set it back to true for other warnings after the fact

regards
Kelvan
 
Top