Performing a quick search..?

[Lior]

Hello,
I'm trying to make a quick search thru numbers which are stored in a database in TEXT format (because I need leading zeroes).My idea is that the search itself will be done like the search in well-known "help" topics (i.e. type one letter and you get to the first word with that letter and so on inside the word itself).
How can I make this search thru V.B while holding the database in MsAccess..?
Please ,please give a hand.
Thank-you!!!

LED

[Lothar Haensler]

I would NOT access the database with every character entered (or deleted) by the user.
Instead, I'd read all keywords into a listview and use the ListView's FindItem method to search the listview upon each Change event of the Text box.

[Lior]

Hello LOTHAR,
I got the point.You do not recommend to leave a database open while search is being performed in run-time.I still do not quite understand how to use the listview though. I want the listview to have a connection with the databse that holds my numbers ,meanwhile I want to see the search being performed in run-time. I have no idea how to perform this .
Can you please help..?

LED

[Lior]

Hi ,
I did not really know how to continue from the point you stopped. I would appreciate it if you could be a bit more specific as to this ListView method. Can you supply a sample code..?
Thank-you.


LED

[Lothar Haensler]

I understand your problem, but currently I do not have the time to develop a sample. You might wanna search MSDN for a sample. I've seen some there.