How to suppress "Inserting..." message [Archive]

View Full Version : How to suppress "Inserting..." message

mud2

04-15-2006, 04:02 PM

When using the SQL INSERT INTO...(a table), each INSERT causes a message box saying "...About to insert..." How to suppress this message...very annoying when INSERTing in a loop!

geekgirlau

04-16-2006, 01:48 AM

DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT INTO blah blah blah"
DoCmd.SetWarnings True