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?
LVL 1
SatTechSolutionsAsked:
Who is Participating?
 
tbsgadiConnect With a Mentor Commented:
SatTechSolutions,
Click the Show All Actions button in the Show/Hide group on the Macro Design
Tools tab.

Gary
0
 
tbsgadiCommented:
Hi SatTechSolutions,

  DoCmd.SetWarnings False

& afterwards
  DoCmd.SetWarnings True


Good Luck!

Gary
0
 
SatTechSolutionsAuthor Commented:
How do I do that in a Macro?  (I haven't worked in Access in about 10 years)
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
tbsgadiConnect With a Mentor Commented:
SatTechSolutions,

SetWarnings No
Gary
0
 
SatTechSolutionsAuthor Commented:
I don't have any option I can see in the Macro called SetWarnings
0
 
tbsgadiCommented:
Did you manage to do this?
0
All Courses

From novice to tech pro — start learning today.