Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1022
  • Last Modified:

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?
0
SatTechSolutions
Asked:
SatTechSolutions
  • 4
  • 2
2 Solutions
 
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
 
tbsgadiCommented:
SatTechSolutions,

SetWarnings No
Gary
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
SatTechSolutionsAuthor Commented:
I don't have any option I can see in the Macro called SetWarnings
0
 
tbsgadiCommented:
SatTechSolutions,
Click the Show All Actions button in the Show/Hide group on the Macro Design
Tools tab.

Gary
0
 
tbsgadiCommented:
Did you manage to do this?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now