PC Review


Reply
Thread Tools Rate Thread

Duplicates in comboBox

 
 
Keith Smith
Guest
Posts: n/a
 
      9th Feb 2005
Is there an easy way to get rid of duplicates in my comboBox? I didn't want
to have to manually write code for this and degrade performance.


 
Reply With Quote
 
 
 
 
Mark Rae
Guest
Posts: n/a
 
      9th Feb 2005
"Keith Smith" <(E-Mail Removed)> wrote in message
news:T6mOd.22869$uc.16966@trnddc09...

> Is there an easy way to get rid of duplicates in my comboBox? I didn't
> want to have to manually write code for this and degrade performance.


Er, at the risk of stating the obvious, by not putting them in there in the
first place... :-)

How are you populating the ComboBox? If it's from a database query, change
the SELECT to SELECT DISTINCT...


 
Reply With Quote
 
Keith Smith
Guest
Posts: n/a
 
      9th Feb 2005
>> Is there an easy way to get rid of duplicates in my comboBox? I didn't
>> want to have to manually write code for this and degrade performance.

>
> Er, at the risk of stating the obvious, by not putting them in there in
> the first place... :-)
>
> How are you populating the ComboBox? If it's from a database query, change
> the SELECT to SELECT DISTINCT...


Duh! Mark, I should have thought of that!

I'll just change to SELECT DISTINCT. Thanks for your input!


 
Reply With Quote
 
Sam Martin
Guest
Posts: n/a
 
      9th Feb 2005
<chuckle>

"Keith Smith" <(E-Mail Removed)> wrote in message
news:Y_mOd.15161$uc.13745@trnddc04...
>>> Is there an easy way to get rid of duplicates in my comboBox? I didn't
>>> want to have to manually write code for this and degrade performance.

>>
>> Er, at the risk of stating the obvious, by not putting them in there in
>> the first place... :-)
>>
>> How are you populating the ComboBox? If it's from a database query,
>> change the SELECT to SELECT DISTINCT...

>
> Duh! Mark, I should have thought of that!
>
> I'll just change to SELECT DISTINCT. Thanks for your input!
>



 
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
Remove Duplicates in ComboBox Freddy Microsoft Excel Programming 1 12th May 2008 12:03 PM
No duplicates in Combobox hinterbichler@gmail.com Microsoft Access 3 9th May 2008 03:27 PM
ComboBox Duplicates DontellTrevell via AccessMonster.com Microsoft Access 3 21st Feb 2007 10:58 PM
combobox - removing duplicates Neil M Microsoft Access Forms 2 31st Oct 2005 01:23 PM
DLookup Combobox with Duplicates =?Utf-8?B?Sk9N?= Microsoft Access 2 8th Sep 2005 05:36 PM


Features
 

Advertising
 

Newsgroups
 


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