Software

Ask something
Discussion Locked

No Duplicates on Data Entry in Access

0 helpful
7 replies

by megan26

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

7 replies

by 3xp3rt

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

by 3xp3rt

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.

by ayuknotna

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.

by konza

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.

by wenno

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

This discussion is closed to new replies.