Access + Insert Into + confirmation dialog

[Joseph Liu]

I am using MS Access 2003 with a DoCmd.RunSQL "Insert into ..." statement.
The statement executes perfectly but everytime when a record is inserted into
an Access table, I was prompted to confirm the insertion. Please advise where
I can eliminate this annoying prompt.

Thanks a lot.

Joseph

 

[Gina Whipp]

Joseph,

DoCmd.SetWarnings False 'Turn warnings off
DoCmd.RunSQL blah, blah
DoCmd.SetWarnings True 'Turn warnings back on

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

I am using MS Access 2003 with a DoCmd.RunSQL "Insert into ..." statement.
The statement executes perfectly but everytime when a record is inserted into
an Access table, I was prompted to confirm the insertion. Please advise where
I can eliminate this annoying prompt.

Thanks a lot.

Joseph

Rather than using RunSQL, use the Execute method:

On Error GoTo Proc_Error
<set up your insertion>
CurrentDb.Execute "Insert Into....", dbFailOnError
Proc_Exit:
Exit Sub
Proc_Error:
MsgBox "Error " & Err.Number " in insert function"
Resume Proc_Exit
End Sub

This will both avoid the warning message AND trap any query errors.