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

+1 Q:

i am filling out a form on a word document which posts to access database,.

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/????

+1 A:

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

Raj More 2010-07-23 19:22:18

is it possible to programmatically do this>?

I__ 2010-07-23 19:22:42

yes yes yes yes i know!!!!!!!!!!!! anyway thanks so much

I__ 2010-07-23 19:28:37

+4 A:

Remove the line from your code.

Tobiasopdenbrouw 2010-07-23 19:22:40

remove which line ?

I__ 2010-07-23 19:23:47

This one `bytContinue = MsgBox("Do you want to insert this record?", vbYesNo, "Add Record")`. But you'll have to rewrite it instead of removing it.

Tobiasopdenbrouw 2010-07-23 19:25:01

thank you very much! that was my negligence

I__ 2010-07-23 19:26:50

+1 for noticing the "other question".

Raj More 2010-07-23 19:27:57

ansaurus