Solved

How do I suppress action query messages in an Access 2007 macro

Posted on 2009-05-13
6
1,008 Views
Last Modified: 2013-11-28
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
Comment
Question by:SatTechSolutions
  • 4
  • 2
6 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24375011
Hi SatTechSolutions,

  DoCmd.SetWarnings False

& afterwards
  DoCmd.SetWarnings True


Good Luck!

Gary
0
 
LVL 1

Author Comment

by:SatTechSolutions
ID: 24375037
How do I do that in a Macro?  (I haven't worked in Access in about 10 years)
0
 
LVL 46

Assisted Solution

by:tbsgadi
tbsgadi earned 250 total points
ID: 24375046
SatTechSolutions,

SetWarnings No
Gary
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 1

Author Comment

by:SatTechSolutions
ID: 24375127
I don't have any option I can see in the Macro called SetWarnings
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 250 total points
ID: 24375181
SatTechSolutions,
Click the Show All Actions button in the Show/Hide group on the Macro Design
Tools tab.

Gary
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24382216
Did you manage to do this?
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question