Duplicates

  • Thread starter Thread starter Ewar
  • Start date Start date
E

Ewar

Can anyone help please?

In table design I can set a field to Index No duplicates but can I alter the
warning message to be more suggestive. i.e. "That username is taken please
try again" if I can't alter the warning can I do this with a validation rule
then use the validation warning box?
Many thanks
Eddie
 
I can't tell from your description if you are trying to do data entry
directly in the table, or are using a form. The latter is preferable --
Access tables store data, Access forms display it (and handle data entry).

If you use a form, you could use the BeforeUpdate event of the control you
bind to the field in question. In this event, you could run code to inspect
the data for matches, and cancel the update if a match is found.
 
Hi Jeff
Is it possible to do at the table stage, so as to be inherited at the form
stage.

Regards
Eddie
 
As far as I know, not in Access.

Jeff

Ewar said:
Hi Jeff
Is it possible to do at the table stage, so as to be inherited at the form
stage.

Regards
Eddie
Click to expand...
 
Back
Top