Append Query Message Box

[Sullivan]

I was wondering if anyone knew how to, when appending to a
table from VB, to not have the message box that appears
when you are appending a row to a table.

I have a log that's hidden from the users that gets
updated when they do transactions with a new row, and it
wouldn't make sense for them to have to click through the
Access message boxes for a table they don't touch.

Sullivan

 

[Timothy C. Doherty]

DoCmd.SetWarnings False
....run query
DoCmd.SetWarnings True

 

[Tim Ferguson]

I was wondering if anyone knew how to, when appending to a
table from VB, to not have the message box that appears
when you are appending a row to a table.

strSQL = "INSERT INTO Something etc..."

db.Execute strSQL, dbFailOnError

The big advantage of this over the DoCmd object is that you can use On
Error to trap any SQL errors in code and deal with them without killing the
data.

Best wishes


Tim F

 

[mlindsay]

Try looking at the following:
http://www.mvps.org/access/queries/qry0012.htm


--

Michael R. Lindsay NCT
(e-mail address removed)
(An old dog still trying
to learn new tricks...)