• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

remove worning messeges

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
rzvika1
Asked:
rzvika1
  • 2
1 Solution
 
HelicopterCommented:
before you activate the query in your code put:
docmd.setwarnings false

then immediately after put:

docmd.setwarnings true
0
 
rzvika1Author Commented:
what about editing the warning text?
0
 
mikkonCommented:
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
 
rzvika1Author Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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