General discussion

Locked

No Duplicates on Data Entry in Access

By megan26 ·
In Microsoft Access, I have one table and am entering new records. As I enter new records, I would like to set up some type of syntax or validation rule where if an address is entered it is not a duplicate of another record. For example, if 1500 Snowcreek Rd, Waterbury, TX 88888 is in another record and I try to enter that same address in a new record it will bring up a message telling me that address is already entered.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by G... In reply to No Duplicates on Data Ent ...

set the address as key(s). The key(s) cannot be duplicated.

Collapse -

by 3xp3rt In reply to No Duplicates on Data Ent ...

An other option (G...'s answer is right) is to write a trigger for insert to your database.

Collapse -

by megan26 In reply to No Duplicates on Data Ent ...

What does that mean to set a trigger?

Collapse -

by 3xp3rt In reply to No Duplicates on Data Ent ...

Triggers allow us to execute a batch of SQL code when either an insert, update or delete
command is executed against a specific table. Triggers are associated with a single table, and are automatically executed internally by SQL
Server. For more info see the MSAccess Help, where you can find exemples how to look like.

Collapse -

by AyukNotna In reply to No Duplicates on Data Ent ...

Go to control panel | Add Remove Programs | Windows Components| internet explorer enhanced security configuration | details | and clear the check box from "for all other user groups". If the user is an Administrator then clear the adminstrators check box as well. Just bewareUsing the SBS server as a workstation is not a recommended practice.

Collapse -

by Konza In reply to No Duplicates on Data Ent ...

You do need to have some conformity in your user's data entry if you set the address to be an index with no duplicates allowed. Example:

1500 Snowcreek Rd, Waterbury, TX 88888
1500 Snowcreek Road, Waterbury, TX 88888

These two entries would not trigger as duplicates.

Collapse -

by wenno In reply to No Duplicates on Data Ent ...

I design view click on the general tab of the field and set the Indexed property to 'Yes (No Duplicates)'

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums