Suppressing warning messages from MakeTable query

  • Thread starter Thread starter John S. Ford, MD
  • Start date Start date
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
 
docmd.SetWarnings = False
'your code
docmd.SetWarnings = true

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

regards
Kelvan
 
Back
Top