right before you start your inserts issue this command

DoCmd.SetWarnin gs False


then right after your done issue this command

DoCmd.SetWarnin gs True