Solved

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

Posted on 1998-10-16
2
183 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
Comment Utility
put
DoCmd.SetWarnings False

before you run the query

(set it to true after though)
0
 

Author Comment

by:skyberg
Comment Utility
Now I remember. You will have You credit-points
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now