Is there a way to get rid append table message?

[arnodys]

Hi, all

I have written some codes to insert data into a table. I'm trying to get rid of the pop up message which say:

You are about to append one row(s).
Once you click yes, you can't use the undo command to reverse the changes.
Are you sure you want to append the selected rows?

Can anyone tell me how to do this?



Cheers

 

[namliam]

Use Currentdb.execute to run the query or do "DoCmd.SetWarnings False"

GL

 

[Dwight]

Go to Tools > Options > Edit/Find and remove the appropriate checkmarks in the Confirm section.

 

[jsanders]

Use Currentdb.execute to run the query or do "DoCmd.SetWarnings False"

GL

Make sure to add "DoCmd.SetWarnings True" at the end of the code to turn it back on.