Duplicate values in index message

[Rick in N S]

In table tblPhones I have an unique index consisting of:

ContactID PK autonumber
PhoneType Text (ie Home; Work; Cell; Mobile; Cottage; etc)

to prevent users from recording duplicate phone types.

When they do attempt to use a phone type the second time
they get the standard Access message:

"The changes you requested to the table were not
successful because they would create duplicate values in
the index, primary key, or relationship. Change the data
in the field for fields that contain duplicate data,
remove the index, or redefine the index to permit
duplicate entries and try again."

How do prevent this standard message message from
appearing and replace it with a less ambigous one such
as "You have already recorded this phone type for this
contact."

 

[Brian]

In table tblPhones I have an unique index consisting of:

ContactID PK autonumber
PhoneType Text (ie Home; Work; Cell; Mobile; Cottage; etc)

to prevent users from recording duplicate phone types.

When they do attempt to use a phone type the second time
they get the standard Access message:

"The changes you requested to the table were not
successful because they would create duplicate values in
the index, primary key, or relationship. Change the data
in the field for fields that contain duplicate data,
remove the index, or redefine the index to permit
duplicate entries and try again."

How do prevent this standard message message from
appearing and replace it with a less ambigous one such
as "You have already recorded this phone type for this
contact."

You can trap the error in the form's Error event. It's error number 3022.

 

[Rick in N S]

Thanks Brian. Curious; how were you able to determine it
is error # 3022?

I tried getting the error number by using an error event
but it did not fire as expected. The standard message
kept coming up without any reference to the error number
of course.

 

[Brian]

Thanks Brian. Curious; how were you able to determine it
is error # 3022?

I tried getting the error number by using an error event
but it did not fire as expected. The standard message
kept coming up without any reference to the error number
of course.

After many years of working with Access, there are some error numbers I know
by heart!

However, in the form's Error event, it's in the DataErr argument. If your
form's Error event is not firing, check in the form's properties window
(events tab) that it reads "[Event Procedure]" against the On Error event.

 

[Rick in N S]

Thanks Brian, most helpful! Final question. I am able to
display the error number in a msgbox as follows:

MsgBox "The error is " & DataErr

Is there any way to display the error description along
with the error number?

-----Original Message-----

Thanks Brian. Curious; how were you able to determine it
is error # 3022?

I tried getting the error number by using an error event
but it did not fire as expected. The standard message
kept coming up without any reference to the error number
of course.

After many years of working with Access, there are some error numbers I know
by heart!

However, in the form's Error event, it's in the DataErr argument. If your
form's Error event is not firing, check in the form's properties window
(events tab) that it reads "[Event Procedure]" against the On Error event.


.

 

[Brian]

Thanks Brian, most helpful! Final question. I am able to
display the error number in a msgbox as follows:

MsgBox "The error is " & DataErr

Is there any way to display the error description along
with the error number?

accesserror(DataErr)