Error number for duplicate key

[Guest]

I have set up a field as indexed with no duplicates. Does anybody know the error code returned by Access 97 so that I can trap it and return an appropriate message to the user?

 

[Allen Browne]

Use the Error event of the form to trap these values of DataErr:
3022 duplicate index value;
3201 related record required;
2113 wrong data type.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have set up a field as indexed with no duplicates. Does anybody know the

error code returned by Access 97 so that I can trap it and return an
appropriate message to the user?

 

[Guest]

Thanks a lot. I appreciate your help.

 

[TC]

You sometimes have to wonder, where is people's initiative?

step 1 - enter duplicate record;
step 2 - read error message!



TC

 

[TC]

Thanks for the compliment

TC

Yes, it is that simple, except that you cannot trap these errors with normal
VBA error handling, and they are not in Err.Number. The Error event of the
form is less obvious to find, and the DataErr values are not listed (AFAIK).

BTW, TC, you have been posting lots of useful answers for people recently.
Thanks.

 

[Allen Browne]

Yes, it is that simple, except that you cannot trap these errors with normal
VBA error handling, and they are not in Err.Number. The Error event of the
form is less obvious to find, and the DataErr values are not listed (AFAIK).

BTW, TC, you have been posting lots of useful answers for people recently.
Thanks.