Append Query Message Box

  • Thread starter Thread starter Sullivan
  • Start date Start date
S

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
 
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.
Click to expand...

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
 
Back
Top