Anybody have any idea how to use VBA to disable the msgbox that pops up with an SQL INSERT or UPDATE

example:

DoCmd.RunSQL INSERT INTO tblTrash (intEmpty) VALUES ('1');

this will pop up a message box that says About to append 1 row.

Same occurs when you do an UPDATE query.

Thanks!!

Andy Delgado

DoCmd.SetWarnings False
DoCmd.RunSQL INSERT INTO tblTrash (intEmpty) VALUES ('1');
DoCmd.SetWarnings True

Remember to set it back to true IMMEDIATELY after issuing your SQL so you get other warnings.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division