disabling notifications

[toddbingham]

Running an append query, appending to table, get notification that it cant append all records. That is OK, I dont want it to tell me that. Can I turn it off?

Thanks.

 

[Calvin]

before the line that executes the the Append Query use:

docmd.setwarnings false

and after the query has finished use:

docmd.setwarnings true

to turn the warning prompts back on.