Solved

remove  worning messeges

Posted on 1998-09-15
4
297 Views
Last Modified: 2008-03-06
i made a query (in code) that deletes some records. when i activate it (by button) worning messeges are shown.
can i remove them? can i change the text that's written in those messages?
0
Comment
Question by:rzvika1
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
Helicopter earned 10 total points
ID: 1962329
before you activate the query in your code put:
docmd.setwarnings false

then immediately after put:

docmd.setwarnings true
0
 

Author Comment

by:rzvika1
ID: 1962330
what about editing the warning text?
0
 
LVL 1

Expert Comment

by:mikkon
ID: 1962331
Do you mean the "This query will modify..." type of messages? If so, you can remove them by unchecking relevant check-boxes in the Options dialog, on the Edit/Find tab (Confirm Action queries).

Of course, you probably want to do this in code:
SetObject ("Confirm Action Queries", False);

You can not change the messages.

0
 

Author Comment

by:rzvika1
ID: 1962332
thank you
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

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