'Help-Find'-style interface for vb4 programmed database search 
Author Message
 'Help-Find'-style interface for vb4 programmed database search


I wonder if anyone can help me with the following.
I'm trying to write a vb4 interface to provide my quite complex and
extremely relational access2 database with the necessary data.

The actual question is if anyone knows how to write a search interface
that resembles the Help-Find interface in almost all win95 apps; i.e.
a combination of a textbox and a listbox (see what i mean?).
The list to be searched contains more than 1000 person/band names.

In fact I managed to create such a thing, and it works (!),  but it
works extremely slow.

According to me, this is why:
the name-list that has to be searched is in fact a union query that is
saved in the db. This query unites three tables ('Bands', 'Persons',
'Aliasses') and results in a huge list of names. So, when I type a
character in the textbox, my program opens the query and performs a
'LIKE'-query on it. With every extra character I add, the program goes
through the same routine, and thus takes the huge union query to do
its search.
Isn't there a faster way to do this?
Can't vb temporarily load the list resulting from typing the first
character into the textbox, and take this temporary table as a (new)
basis for the search routine when typing a second character in the

Anyway, I hope I'm not talking Chinese (it's Flemish in fact...)

or via this newsgroup.

Thanks a lot.

Thu, 07 Sep 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. 'Help-Find'-style interface for vb4 programmed database search

2. VB4 - Error 53 'File not found'

3. VB4 - Error 53 'File not found'

4. How to program a 'Find' facility

5. 'System Database' property not found

6. 'Physical database not found'

7. 'Physical database not found' error message

8. 'Creating' Databases in VB4

9. Help! Program Can't Find system directory

10. Replacing styles doesn't set .Found=True

11. Can't find existing styles?

12. VB5 vs VB4 - example program in help doesn't run


Powered by phpBB® Forum Software