Too many message boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have access as my interface to a mysql database. I use the mysql odbc
driver to connect and everything works fine; however, whenever I make an
insert or update to the database I get message boxes telling what is going
to happen and if it is okay. I have some sections of code that might update
the database 3 or 4 times and it is getting annoying to continually have to
accept the message boxes. Is there a way to turn those off?
 
Try:
SetWarnings
Don't forget to turn it back on again.

Alternatively, use the Execute method of CurrentDb() instead of RunSQL.
 
Thanks, that did it.

Allen Browne said:
Try:
SetWarnings
Don't forget to turn it back on again.

Alternatively, use the Execute method of CurrentDb() instead of RunSQL.
Click to expand...
 
Back
Top