zaboo9
07-21-2010, 07:28 AM
I have a list of customers that contains 65,000 rows with 24 columns of information that I'm matching against another record of customers with 1,100 rows and 26 columns that came from a different database. I have code that automatically finds matches based on a social-security number, however; I need to now manually find items that don't have a direct social security match (ie, street address, zip, storeName, etc)
The names and address hardly ever match because they don't have the same column headings, and there were different input standards used; ie. 100 W 900 N in one could be typed 100 west 900 North, or 100 we 900 no, or even 100 n. 900 w.
Now to the question: Is there a way to implement a form of Ajax that will pull up potential matches automatically when I start typing information? (like it works on google)
Just wondering if it's even possible, and if it is, where could I find an example of this using VBA? Thanks!
The names and address hardly ever match because they don't have the same column headings, and there were different input standards used; ie. 100 W 900 N in one could be typed 100 west 900 North, or 100 we 900 no, or even 100 n. 900 w.
Now to the question: Is there a way to implement a form of Ajax that will pull up potential matches automatically when I start typing information? (like it works on google)
Just wondering if it's even possible, and if it is, where could I find an example of this using VBA? Thanks!