How do I suppress action query messages in an Access 2007 macro
Posted on 2009-05-13
I have an Access 2007 database that uses a macro to first run a delete query to empty a table, then uses an insert query to populate the table, then runs a report off the table. I'm not real keen on this method, but it's how the DB owners want it.
The problem is that when they run the macro, you get 4 messages, confirm you want to run the delete, confirm you want to delete x records, confirm you want to run the insert, confirm you want to insert x records.
I would like to be able to suppress these messages. Is there any way to do this?