Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1020
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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