 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Picking out words in a text field
I have a text field that contains names and numbers separated by a coma. Ex (2031 Mary Jane Smith, Jim Anderson, Bill Wright) what I'd like to do is find Mary and then look her up in the student master file (there will be only one Mary Jane Smith in the file), when I've done that I want to move to the next person in the list and find him in the student master. What's the best way to search through this field and get each person out. Thanks for all your help. Tom That is an almost impossible task, Tom. Name matching and Address matching are never going to be 100% accurate. There are too many variables. You have already encountered one. How do we know Mary Jane Smith is Mary Smith in a table field? Sure, you can do some string manipulation to take the middle name out and search by first and last, but then you have the problem of people who have multiple middle names (George Herbert Walker Bush) and those who have either first are last names that have a space in them (Rip van Winkle, John Wilkes Booth Jr). And, we haven't even discussed data entry errors. But, as a strart, use the Split function to create an array of the names you will try match and loop throught the resultant array using DLookup to try to find them. Best of luck.  SignatureDave Hargis, Microsoft Access MVP > I have a text field that contains names and numbers separated by a coma. Ex > (2031 Mary Jane Smith, Jim Anderson, Bill Wright) what I'd like to do is find [quoted text clipped - 5 lines] > Thanks for all your help. > Tom Not to sure about the split function? Couldn't I search for the end of the string and then work backward until I found the coma and that would be one person, I know for a fact that each name is separated by a coma. > That is an almost impossible task, Tom. Name matching and Address matching > are never going to be 100% accurate. There are too many variables. You have [quoted text clipped - 21 lines] > > Thanks for all your help. > > Tom Split function is less work. Dim varNameList As Variant Dim lngX as Long varNameList = Split(txtAllName, ",") For lngX = 0 To Unbound(varNameList) 'Here is where you try to find the name Next lngX SignatureDave Hargis, Microsoft Access MVP > Not to sure about the split function? Couldn't I search for the end of the > string and then work backward until I found the coma and that would be one [quoted text clipped - 25 lines] > > > Thanks for all your help. > > > Tom I'll give that a try and let you know. Thanks for all your help. > Split function is less work. > [quoted text clipped - 35 lines] > > > > Thanks for all your help. > > > > Tom In the statement For LngX t= 0 to Unbound(varNameList) what is the Unbound? > Split function is less work. > [quoted text clipped - 35 lines] > > > > Thanks for all your help. > > > > Tom That should be UBound, not Unbound. UBound represents the largest available value in the array Signature_________ Sean Bailey > In the statement For LngX t= 0 to Unbound(varNameList) what is the Unbound? > [quoted text clipped - 37 lines] > > > > > Thanks for all your help. > > > > > Tom Ubound misspelled :) SignatureDave Hargis, Microsoft Access MVP > In the statement For LngX t= 0 to Unbound(varNameList) what is the Unbound? > [quoted text clipped - 37 lines] > > > > > Thanks for all your help. > > > > > Tom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.