How to stop Access warnnings

[MBMSOFT]

Any idea how to stop access warnnigs in vba when input value is diferent then validation rule or diferent then input mask format....
I want to have my message ...i don't need access warnning


i tried with error handling but i didn't succsed ,docmd.setwarnnings false doesn't prevent from messagess as well ....

 

[Khalid_Afridi]

Any idea how to stop access warnnigs in vba when input value is diferent then validation rule or diferent then input mask format....
I want to have my message ...i don't need access warnning


i tried with error handling but i didn't succsed ,docmd.setwarnnings false doesn't prevent from messagess as well ....

What message you are getting? to just set the warning off and on do this:

DoCmd.SetWarnings False
your code....
.......
.......
DoCmd.SetWarnings True

 

[Mr. B]

I you do not want the validation rule to cause the display of the message, remove the validation rule at the table level.

 

[MBMSOFT]

it's a metter when i have validation rule or input mask in control and when if it is wrong i have acceess message like it is not aloowed that value , but i dont want that message

ex: inputmask 0000;;

if i enter characters like"SADSAD" INSTEAD OF NUMBERS

I GOT ACCESS MESSAGE ... I'D LIKE TO TURN OF THAT MESSAGE BUT STIIL TO HAVE THE INPUT MASK

WARRNINGS OFF DOSENT PREVENT THAT ACCESS MESSAGE

 

[Khalid_Afridi]

so you want to show your own msgs to appear...
Check this for validateion rules.

The Validation Text property is the message displayed by Access if a value does not meet your validation rule. In other words, if your validation rule checks whether a value is outside a certain range, and the value is outside that range, Access displays the validation text in a dialog box. As an example, let's assume that the following are your settings for the Validation Rule and Validation Text properties:

In this case, if you tried to enter a value lower than 20 in the field, then Access would display an error message dialog box, as shown in Figure 3-5.

Figure 3-5 A validation rule error message dialog box.

 

[MBMSOFT]

ok, thanks a lot
and what about input mask.....
when the entered value is different then it is required format defined in inpput mask
how i can put my message
ex : 000\-00000\-00;;
if i enter
123-FGDSASG-00
I WANT TO HAVE MY MESSAGE

 

[SOS]

You don't get your own messages for input masks.