If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Entering Data in a form
Hi,
I'm trying to create a database for a church that consists of some of the following fields: Autonumber, Fname, Lname, address, date of birth, email, phone, My question: Is there a way that I can get a warning message (for duplicated records) when I use a form to enter the records? Because, I cannot use their SSN, or any other unique number that identfies each person. So I need to know if I ever enter a person with the same Fname, Lname, Address... I know that there might be multiple people with the same Lname, and Fname, but not address. But at the same time, there might be multiple people with different names with the same address (family) Or, do you have a better solution to this? Thanks. John |
#2
|
|||
|
|||
Entering Data in a form
If you are comfortable with VBA code, you could use the BeforeUpdate event
procedure of the *form* (not control) to look for duplicates. You could use DLookup(), using the Fname, Lname, and Address fields in the criteria (3rd string.) However, there could be multiple duplicates, so it's a bit more involved than that. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "John" wrote in message ... I'm trying to create a database for a church that consists of some of the following fields: Autonumber, Fname, Lname, address, date of birth, email, phone, My question: Is there a way that I can get a warning message (for duplicated records) when I use a form to enter the records? Because, I cannot use their SSN, or any other unique number that identfies each person. So I need to know if I ever enter a person with the same Fname, Lname, Address... I know that there might be multiple people with the same Lname, and Fname, but not address. But at the same time, there might be multiple people with different names with the same address (family) Or, do you have a better solution to this? Thanks. John |
Thread Tools | |
Display Modes | |
|
|