rich,
I assume your users are aware that if they start typing the list will
automatically scroll - right! otherwise I bet your company has had to
replace quite a few mice over the past year (scroll wheel dieing)...
That being said ... here is a work around...
------------------------
- text box ...
- delay timer event ...
- popup window ...
= user control!
------------------------
- user starts entering the persons name...
- wait for a split second delay in the typing ... or after the first 3 chars
are recieved... something.
- popup a window ... just below the text box ... populate a grid control in
the window ... filtered list of the 30,000 people based on user entries ...
allow the user to select a value in the popup!
....
if the user wants to 'scroll the entire' list looking for Stewart Smith ...
give'em a hot-key to popup the window ... retrieve the first 2000 records
.... show the popup ... in the background continue populating the list!
But I agree with Stephany, your design is flawed if you are presenting the
user with a combo box of 30,000+ options! I once had a college manually
scrolling our clients list (2,000 records) to find Simpson Construction Ltd
.... she had been doing this for 3 years ... i work over, typed Simp ... the
selection was in the box ... u should have seen her expression! So,
hopefully, you do not have a user that thinks they need to scroll the entire
list to find employee ... Zoo Zoo ...
Jeff
"Rich" <Ri**@discussions.microsoft.comwrote in message
news:A9**********************************@microsof t.com...
One thing I noticed about the Access combobox is that it is not loading
everything all at once. Like when you scroll in the Access combobox there
is
hesitation while it loads data... Whereas, the VB2005 combobox loads all
the
data at once.
I would prefer to load the data as needed rather than all at once and have
the form that contains the combobox display right away. Is there a
property
setting in the comobox somewhere to achieve this kind of behavior?
"Rich" wrote:
>Greetings,
I have to load 30,000 unique names into a combox. Filling a dataTable
takes
only a few milliseconds. But populating the combobox and displaying the
list
takes several seconds - way too long. A user selects a name from the
combobox and runs a query.
Originally, this combox was on a form in an MS Access ADP which was
linked
directly to our sql server. The combobox populated withins millisecnods.
How can I achieve this kind of performance in my VB2005 app? what is the
bottle neck here?
Thanks,
Rich