Error using Collection

[Micron]

I have looked but cannot find anything definitive about a default type for a collection. A lot of documentation refers to adding objects to a collection, but also says that the collection itself can contain different types. That and the fact that in your procedures, one added data from a string variable (which worked) while the other added the same data from a variant. If coercing the variant to a string (CStr) or declaring the faulty variable as a string fixed the problem, it seems logical that the collection default type is an object.

For what you're doing, have you considered using a dictionary object? Apparently keys are more useful.

[moke123]

For what i'm doing the keys only purpose is to weed out the duplicates. I'm still waiting for that AHA! moment with dictionaries. I've read a bit about them but haven't
seen a demo or some code that makes me say "Now I get it."

[June7]

Did you consider suggestion to use DISTINCT in the query?

[moke123]

hi June,
I'm making three comparisons for the matches, Exact, levenschtein distance, and soundex to catch variations and spelling mistakes in the inputted name.
Basically my Sql selects the whole table or a subset of the table based upon the first letter of the inputted first or last name.
It works well enough that I haven't had a duplicate since I began using it.
Heres an example although my actual implimentation is much more complex.

searchdb.zip