Solved

Message-suppresion in a DoCmd.OpenQuery "....."

Posted on 1998-10-16
2
187 Views
Last Modified: 2008-02-01
Is it possible to suppress the normat message from a Update-query   DoCmd.OpenQuery ?
0
Comment
Question by:skyberg
2 Comments
 
LVL 8

Accepted Solution

by:
Helicopter earned 30 total points
ID: 1965622
put
DoCmd.SetWarnings False

before you run the query

(set it to true after though)
0
 

Author Comment

by:skyberg
ID: 1965623
Now I remember. You will have You credit-points
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

809 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