Change built-in error messaege 3022

Geir Arne · #1 (**permalink**) 01-29-12, 15:19

Hello,

I wonder if someone can help me with a problem. I know that I can to turn off the built-in error message when a record is causing duplicate and replace it with my own error message in the form by using the "on error" event, but I want to get error message when I leave the field not after I have saved the record. How can I get it to error message to appear when I go to the next field?

Best regards
Geir Arne Hansen

MStef-ZG · #2 (**permalink**) 01-30-12, 03:12

Look at "DemoDupliNHSA2000.mdb" (attachment, zip).
Open Form1 and try.

Geir Arne · #3 (**permalink**) 01-31-12, 01:29

Thanks for the answer, but I can not open the zip file I get up a error message "Can not open file: it does not Appears to Be avalid archive" when it opens the file is empty. Can you please try again.

regards
Geir Arne

MStef-ZG · #4 (**permalink**) 01-31-12, 02:23

Which Access you have got ??

Geir Arne · #5 (**permalink**) 01-31-12, 03:59

I have Access 2010

MStef-ZG · #6 (**permalink**) 01-31-12, 04:00

I don't know. My Demo is Access 2000.

Geir Arne · #7 (**permalink**) 01-31-12, 04:10

Sorry I make me misunderstood, the problem is that I get the error message when I try to open the file in winzip. I get the message "Can not open file: it does not Appears to Be avalid archive". then winzip open with no files

Internet Services

Web Development

Digital Marketing

Consumer Tech