PC Review


Reply
Thread Tools Rate Thread

Combo box and entering data

 
 
jayderk
Guest
Posts: n/a
 
      25th Nov 2003
I have a combo box of customers.
the problem: they can have 10000 customers in the list and that is terrible
programming to have the combobox object hold that many items.

does anyone have any suggestions on how to make a search criteria for this?

for example when you start entering a address in Internet explorer, it
'filters' it so eventually you can select one of 20.?

any assistance would be greatly appreciated.


regards,
Jay


 
Reply With Quote
 
 
 
 
Peter Foot [MVP]
Guest
Posts: n/a
 
      26th Nov 2003
How about a control which lets the users select from groups of letters, a-c,
d-f etc and the only load the required subset. Or using a textbox allow the
user to enter a few letters and search for a partial match using the 'LIKE'
SQL operator or similar.

Peter

--
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org

"jayderk" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I have a combo box of customers.
> the problem: they can have 10000 customers in the list and that is

terrible
> programming to have the combobox object hold that many items.
>
> does anyone have any suggestions on how to make a search criteria for

this?
>
> for example when you start entering a address in Internet explorer, it
> 'filters' it so eventually you can select one of 20.?
>
> any assistance would be greatly appreciated.
>
>
> regards,
> Jay
>
>



 
Reply With Quote
 
Alex Furman
Guest
Posts: n/a
 
      26th Nov 2003
If it is possible to group customers you can use a tree control. I usually
save each group in a separate file and load it on demand into the tree
control.

"jayderk" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> I have a combo box of customers.
> the problem: they can have 10000 customers in the list and that is

terrible
> programming to have the combobox object hold that many items.
>
> does anyone have any suggestions on how to make a search criteria for

this?
>
> for example when you start entering a address in Internet explorer, it
> 'filters' it so eventually you can select one of 20.?
>
> any assistance would be greatly appreciated.
>
>
> regards,
> Jay
>
>



 
Reply With Quote
 
garfitz
Guest
Posts: n/a
 
      26th Nov 2003
Or categorise via a treeview control...

"Peter Foot [MVP]" <(E-Mail Removed)> wrote in message news:<eJ5i99$(E-Mail Removed)>...
> How about a control which lets the users select from groups of letters, a-c,
> d-f etc and the only load the required subset. Or using a textbox allow the
> user to enter a few letters and search for a partial match using the 'LIKE'
> SQL operator or similar.
>
> Peter
>
> --
> Peter Foot
> Windows Embedded MVP
> OpenNETCF.org Senior Advisor
> www.inthehand.com | www.opennetcf.org
>
> "jayderk" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > I have a combo box of customers.
> > the problem: they can have 10000 customers in the list and that is

> terrible
> > programming to have the combobox object hold that many items.
> >
> > does anyone have any suggestions on how to make a search criteria for

> this?
> >
> > for example when you start entering a address in Internet explorer, it
> > 'filters' it so eventually you can select one of 20.?
> >
> > any assistance would be greatly appreciated.
> >
> >
> > regards,
> > Jay
> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update a combo box contents in one form after entering data in ano David K. Microsoft Access Getting Started 3 22nd Mar 2009 07:10 PM
combo boxes entering data Paul Microsoft Excel Programming 8 19th Oct 2008 04:12 PM
entering and retriving data with combo box (with form and subform) =?Utf-8?B?TWV3?= Microsoft Access Forms 0 24th Aug 2007 05:10 PM
Run Time Errors when Entering Invalid Data in Combo Box bg_ie@yahoo.com Microsoft Access Forms 1 29th May 2007 08:06 PM
combo box and entering data =?Utf-8?B?TWlrZSBC?= Microsoft Access Forms 2 21st Jul 2004 07:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:42 PM.