SatTechSolutions
asked on
How do I suppress action query messages in an Access 2007 macro
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?
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?
ASKER
How do I do that in a Macro? (I haven't worked in Access in about 10 years)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I don't have any option I can see in the Macro called SetWarnings
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you manage to do this?
DoCmd.SetWarnings False
& afterwards
DoCmd.SetWarnings True
Good Luck!
Gary