DoCmd.SetWarnings False
If you're running queries. I would not implement them line until you're
certain the queries are functioning properly since if the query craps
out, you won't know unless you examine the underlying data. You'll
probably also want to use the DoCmd.Hourglass True (? - or whatever the
statement is) to communicate that the process is running.
