L
lexrpcv
I am trying to alter the generic "Contacts" database in Access 2007 with a
database I imported. Designing forms is very challenging as I am not
particularly well versed in the expressions language. The Contact Details
form has a duplicate warning in the upper right corner, but it is set to
control for a full name field that I do not have, I have a First Name and a
Last Name field. I have tried to create a new field with both names in one,
but can't get the expression to make a new field in the table. I suspect it
would be better to alter the expression in the form itself, but all the
things I've tried haven't worked--I think because I am confused by all the (
" and ' and what they do.
So, the original expression (in the Contacts Template) is
=IIf(DCount("*","[Contacts Extended]","[ID]<>" & Nz([ID],0) & " And [Contact
Name] = '" & Replace(Nz([Contact Name]),"'","''") & "'")>0,"Possible
Duplicate","")
I don't have a Contacts Extended Query, I just have my master DB [Jordan
Contacts Master].
Please help me understand how to alter the text, as duplicates are
definitely a problem with the number of people who will be entering text.
Thank you!
database I imported. Designing forms is very challenging as I am not
particularly well versed in the expressions language. The Contact Details
form has a duplicate warning in the upper right corner, but it is set to
control for a full name field that I do not have, I have a First Name and a
Last Name field. I have tried to create a new field with both names in one,
but can't get the expression to make a new field in the table. I suspect it
would be better to alter the expression in the form itself, but all the
things I've tried haven't worked--I think because I am confused by all the (
" and ' and what they do.
So, the original expression (in the Contacts Template) is
=IIf(DCount("*","[Contacts Extended]","[ID]<>" & Nz([ID],0) & " And [Contact
Name] = '" & Replace(Nz([Contact Name]),"'","''") & "'")>0,"Possible
Duplicate","")
I don't have a Contacts Extended Query, I just have my master DB [Jordan
Contacts Master].
Please help me understand how to alter the text, as duplicates are
definitely a problem with the number of people who will be entering text.
Thank you!