hello to all friends
I have 5 fields in the subform called (name1 , name2 , name3 , name4 , NFather )
but I Want when complete the 4 names and if NFather similar show me Error message
thanks
hello to all friends
I have 5 fields in the subform called (name1 , name2 , name3 , name4 , NFather )
but I Want when complete the 4 names and if NFather similar show me Error message
thanks
If NFather similar to what - a name already in database? String pattern matching is not simple nor is it conclusive. Review http://allenbrowne.com/vba-Soundex.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You can easily determine if the exact same spelling exists. But you said 'similar' in your question. But why can't the same spelling be in another record? Many people have the same name.
If you want to prevent a duplication of a combination of the 5 fields, then set them as a composite index. This will force the entire record to be unique. If any one of the fields has a different value then the record is unique and not a duplicate. Review http://www.geeksengine.com/article/c...ex-access.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes, you are right
But I wanted to be just said one example ....
I'm very grateful if you can complete the sample
no duplicate.zip
Suggest you delete the duplicates then set the composite index.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.