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?
rzvika1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
HelicopterConnect With a Mentor Commented:
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.

All Courses

From novice to tech pro — start learning today.