how do i suppress: "do you want to insert this record" on SUBMIT?

i am filling out a form on a word document which posts to access databa开发者_如何学JAVAse,.

does anyone know if there a way to suppress the message "do you want to insert this record"???

raj mentioned that this is possible to do manually, uncheck ACTION QUERIES, but can i do this programmatically/????

Given your other question...

Remove the line from your code.

Here is how to fix it

Run MS Access open a database. In the menu, under Tools / Options, uncheck the check-box for ACTION QUERIES.

This is machine specific (not database specific).

This is possible through VBA but only for the current running instance. You can do DoCmd.SetWarnings FALSE

LOL...

In your "other question" referred to, you are asking this question in code

bytContinue = MsgBox("Do you want to insert this record?", vbYesNo, "Add Record")

Just replace that line with

bytContinue = vbYes