Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  HOME    TRACKER    Visual Basic

Remove Duplicates From ComboBox

Ok my combo boxes get filled using a database on formload.

Is there a way to see if something is already in the combo box therefore not adding it again ? (Assuming this would be slow?)

or does anyone have a quick function to remove duplicates?

View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Remove Duplicates In Combobox
i have a combobox that displays the values in my field.....

field: Food
values: cookies, apple, spaghetti, chocolates, cookies

i want to remove the duplicates from showing in the combobox. (but it should be still in my database...) i just want to remove or disable it from showing because it is unnecessary for the user....

please help me out... thanks...

Filling A Combobox From Database But I Don't Want Duplicates In Th Combobox.
I want to output the contents of a database field (ms access) to a combobox but the field has many duplicates that I wish not to display. I just want one of each. Thanks

Remove Duplicates
Im 1/2 way through my project, and i need be able to remove duplicate lines from a text file - im completely stuck

i need it to be as optimised as possible
any ideas?

Need To Remove Duplicates
Anyone know of a fast/easy way to remove duplicates when importing largeamounts of information from a file?

Remove Duplicates In Excel
Hi all,

I have a excel with 1000 cells of some sort of text let say Name. I want to remove duplicates. How can I do that?

If I run a macro on it, it should remove all duplicate Names. All the names should come only once.



Remove All Duplicates From Array
First...I have an array of a number that varies...between 2 and 14. I want to be able to check if all the current number values in the array are of the same value. Example:
i have an array: Temp(6) as integer
every number in the 7 slots for temp = 9
i need way way to check if all of them are equal. But not always is the number going to be a 9, it could be anything from 1 to 14...Im kinda stumped on this...i think i would have to do some sort of
for i = 0 to ubound(temp)
if temp(i) = temp(i+1) then
if temp(i+1) = temp(i+2) then
but thats not working to well for me...can anyone help me out a bit.
If you need more info, please repond, or if it isnt clear enough, please respond.
THanks for looking


How To Remove Duplicates From A List Box?
How do I remove duplicates froma list box?

Use Of Group By To Remove Duplicates...?
Hello everyone,

I am a newb at SQL so please bare with me when I ask:
Will using a group by clause in a SQL query return only unique values in the field that the query is being grouped by?

For example If I use:

select ChipName, WaferName, Date
from tblChipInfo
group by ChipName;

Will my query only display values for WaferName and date where the ChipName is unique?

I have attempted executing a statment similar to this but am getting an error stating that the other field names in the select statement are not part of aggregate functions.

Please help...

How Do I Remove Duplicates In A Database??
I want to wash a database, and remove all duplicates in a 'contact' table. Does anyone have a query for this purpose??

Thanks in advance.

Remove Duplicates From A Listbox?

Here's an example listbox:


Hello World
Hi World
Hello World

How would I go about removing just one of the "Hello World" entries?

And this also needs to work with multiple duplicated text and without me specifying the duplicates.

Basically I need some code to check through a long listbox, find duplicates and remove them. (if there's 2 duplicates, remove 1, if theres 3 duplicates, remove 2 etc. etc.) I hope I've explained that enough for you to understand.

Remove Duplicates In Array
Hi guys i have some code parsing a log i have extracted the lines i want but appart from time stamp there are many duplicates. i have removed the time stamp so now they are duplicates how can i only write to a text file a line from the array if if does not allready exist? but if it does exist then move to next entry so i only end up with one off entries.

like the

21:02:06 11:16:13 john checked in
22:02:06 13:01:59 john checked in

looks like this

john checked in
john checked in

only want to write one entry to the text file and move on to the next.

thanks in advance

How Do You Remove Duplicates From A List Box?
i need to get rid of duplicate entries in a listbox? how would i go about this?

thanks alot

Remove Duplicates From A Combo Box
this is the code for the listbox
Dim i As Long
Dim j As Long
With List1
For i = 0 To .ListCount - 1
For j = .ListCount To (i + 1) Step -1
If .List(j) = .List(i) Then
.RemoveItem j
End If
End With

End Sub

this is the best i can alter the code

Dim i As Long
Dim j As Long
With cboIUpREF
For i = 0 To .Items.Count - 1
For j = .Items.Count To (i + 1) Step -1
If .Items.Item(j) = .Items.Item(i) Then
End If
End With

the line "If .Items.Item(j) = .Items.Item(i) Then" causes an error, what could i change it to, or is there another way other removing dups from a combo box, im using

Remove Duplicates From A Combo Box
Hi, can anyone tell me how you can remove duplicate items from a combo box, iv already searched the forum and theres explanations for removing dups from only listboxes, does any one have any ideas, im using

Faster Way To Remove Duplicates??
This routine does okay if I have a few hundred items in the listview but if I have about 3,000 items, the program hangs and takes forever. Does anyone know a faster way to do this?

Private Sub Command1_Click()
Dim i As Integer
Dim j As Integer

With ListView1
For i = 1 To .ListItems.Count
For j = .ListItems.Count To (i + 1) Step -1
If .ListItems(j) = .ListItems(i) Then
.ListItems.Remove j
End If
End With
End Sub

Remove Duplicates From Listview
I searched on this board on how to remove duplicates from a listview and got the code below but when I run it, the program crashes and ends asap. Does anyone know why or another solution?


VB Code:
Dim i As LongDim j As LongDim Current As StringFor i = ListView1.ListItems.Count To 0 Step -1   'loop the listview control  Current = ListView1.ListItems(i)  'sets the current list item  For j = ListView1.ListItems.Count To 0 Step -1  'now loop for the victims    If j <> i And ListView1.ListItems(j) = Current Then  'we found a match!      ListView1.ListItems.Remove j 'now remove it      'add more code here to execute when finding a match if you wish    End If  Next jNext i

Remove Duplicates In A List
Here's the code:

Sub remove_dupe_list(lst As ListBox)
For a = 0 To (lst.ListCount - 1)
X$ = LCase(lst.List(a))
For b = 0 To (lst.ListCount - 1)
Y$ = LCase(lst.List(b))
If a <> b And X$ Like Y$ Then lst.RemoveItem b
Next b
Next a

End Sub

But when I use it, my program freezes. Anyone have a better code or can fix it?

Remove Duplicates From Array
hello, does anyone have a function to remove duplicates from an array (consisting of strings)?

thanks in advance

How Remove Duplicates In DataCombo?
In a form, i don't know how to remove duplicates in a data combo. My database is a database Access.

Find And Remove Duplicates In 1 Table?

The Access table, tblOwners, has about 200,000 owners. It's been filling for a couple of years. I just took over someone's position.

The SQL statement: SELECT DISTINCT OwnerID FROM tblOwners
returned about 180,000 records. So, I've got about 20,000 duplicates!

Question: Before I continue writing a VB .exe that uses the database, I want to remove all the duplicate records from the table.

Is there a way to clean it up?

Many thanks,

P.S. I've searched through this post on the subject and found I could place the DISTINCT records into another table, and then delete the tblOwners. Is there another way?

When Duplicates Exist - Remove First Instance?
I'll do my best to explain what I need to do.

Lets call this Text1:



From this textbox I want to remove the first "321" and leave the second one in the textbox. How would I go about doing this?

How Can You Remove Duplicates In A Textfile That Is 200mb Big?
Anyone know how I can do this in VB? Is it possible?

Find And Remove Duplicates From A ListView
Can anyone find me a code to find and remove and duplicates in a ListView? I've tried a couple but they didn't work out right. The reason why I need this is because I'm making a program that adds sites to a file and then loads them up again in the ListView.

What Is The Fastest Possible Way To Remove Duplicates In A Listbox?
i haev 27000 items ina listbox.. what is the fastest method of removing duplicates?

Remove Duplicates And Sort Array
I have a large string array and I need to remove the duplicates and sort the array alphabetically.

I know I could do this through a good bit of code and some loops, but I've found more than a few times what I went about coding from scratch was already available in a function.

My best bet for fastest way to sort is through a list box invisible to the user. Is there a better way?

The only way I know of to remove the duplicates in the array would be with a nested loop searching from the beginning each time until it's determined that the string is unique and then on to the next string.

I'm guessing VB provides a quicker way.

Toolbox ICON Duplicates... Why And How To Remove Them....
This is a totally Newbie question but still I want to "clean-up" my toolbox from a particular application project. The jpeg attachment shows how my toolbox looks.... Label, option button, image and others are duplicated... why and how can I remove them (they must be there for a reason) without causing a problem to my app???



Remove Duplicates From A String Separted By Vbcrlf
Hi all.
I am having a MultilineTextbox with strings separted by vbcrlf.How can I remove the
duplicates from the string.What I do is split the string,loop through the string and find
and then remove the item.Is there any simple method avl.


Remove Duplicates Array - Text File
Hi guys i was wondering is there a way to remove duplicates in a text doc but they may not be complete duplicates example as follows

3.1.07 walking with john
4.1.07 walking with john

basically i have many repeat instances of same near same thing in a server log i want to remove the duplicate as its the same other than date stamp. also i wont know what comes after "walking with" "could be any thing here"

thanks in advance i tried removeing time stamp from each line and then removeing duplcates but with 300000 lines it seems to be never ending i am thinking that it will be never ending regardless but heres hoping

Getting Rid Of Duplicates In ComboBOX
Alright, in my Database I have many samples that are frozen on different dates.

What I'm trying to do is create a combo box with all the dates included. And when a date is selected, display all the samples that were frozen on that date in a listbox.

However, I've run into a problem already in that when I choose to make the combo box from the date column of my table, it takes all the dates, even the duplicates. For example, if there are 3 samples frozen on june 20th. there will be 3 june 20th's in the combo box. How can I get rid of this. I tried the removeitem property but it's not working. It says I'm not able to use this property when the combo box is connected to a data table or something when I go to help. ANY SUGGESTIONS?


Getting Rid Of Duplicates In Combobox
Well, the title says it all.
I am populating a combobox with the content of a table.
I would like to get rid of all the duplicate entries in my combobox.
Is there a simple way to do so ?

Duplicates In Combobox
is there a property in combobox that excludes the possibility of duplicates in the list, i've checked but in vain!! for the moment i'm using a loop to check and then i add... but it's **** slow!!!

I'll be among the best soon, very soon!!!

Combobox Duplicates After Save...
I have a combobox that is populated with the code below. When the program is first run, the combobox doesn't have duplicates, but after a save is made, it will duplicate each entry once. I'm sure it's something easy I'm missing, I just haven't found it, yet.

If rs.RecordCount > 0 Then
Do While rs.EOF = False
cmbVendor.AddItem rs!VENDOR_ID
End If

Prevent Combobox Duplicates
I know how to search both a listbox and a combo box for duplicate entries and remove them.

What I would like to do is prevent a duplicate from ever getting entered in the first place.

How would I do that?

Combobox: Automatch Item, Select In Other Combobox, Remove From Both
I have 2 comboboxes and a listbox. I want the user to select an item from one combo, with then matches the item to its corresponding item in the 2nd combo, then add both to a list box. The user can either select from the 1st combo or from the 2nd...either one will match to the corresponding item in the other. Both comboboxes also have to be autocompleting. Once the selection is added to the listbox, the user can remove it which will delete the item from the list and add them back into the appropriate comboboxes. I have this working except for one thing.

When autocompleting, if the user types in what they want and its found and they hit ENTER, I am getting an error when trying to remove the item from the combos. It tells me the index is invalid and sure enough, when I check what the index is, its -1. It seems that the user isn't selecting an item in the combo even though its matched.

This is what I tried. It works if an item is clicked or chosen by pressing the up/down arrows. It also works if they type what they want, its matched, then they press up/down or some other number but will NOT work if they just type it, its found and they hit enter:

Private Sub cmdAdd_Click()
List1.AddItem cmbo(0).Text & " " & cmbo(1).Text

cmbo(0).RemoveItem (cmbo(0).ListIndex)
cmbo(1).RemoveItem (cmbo(1).ListIndex)

End Sub

Oddly, if I put the opposite combo item to be deleted, it, if I just selected something from combo 1, the following works:

Private Sub cmdAdd_Click()
List1.AddItem cmbo(0).Text & " " & cmbo(1).Text

cmbo(0).RemoveItem (cmbo(1).ListIndex)
cmbo(1).RemoveItem (cmbo(1).ListIndex)

End Sub

Any ideas anyone? Perhaps I need to post the function I use for autocompleting? Let me know please...

Checking For Duplicates In Combobox History...

I have a combo box which stores the history of folder paths i've browsed to. I have no problems adding paths to a combo box, I just can't get my brain around the code for checking for duplicates...I tried searching the vbCity for an answer to no avail...

This is my code...It doesn't work, because it only checks the current value in the string, not the entire combo box contents:

Code:cboPath.Text = strPathVar
For i = 0 To cboPath.ListCount - 1
    If cboPath.List(i) <> strPathVar Then
       cboPath.AddItem strPathVar
       'Do nothing
    End If

Thanx in advance...

Edited by - D-Race on 8/14/2005 6:26:28 AM

Can I Remove The Highlight In The Combobox?
Hi, I have a form with some combobox inside, every time the form is load up, the first data in the first combobox is highlighted, is there anyway to prevent it?
Also, is it possible to unhighlight everything when I just simply click the mouse on the form?


How To Remove Items From A ComboBox?
Without knowing the number of items in it?



Array Combobox Remove
Hi i'm having some trouble trying to remove data from an array
I am able to add items from a text box into a combobox which is then stored in an array but I can't seem to remove any. Here is what code I thought would work plz give any advice you can.

cmbServices1.RemoveItem services(servpoint, 1)

any further info u need plz ask.

Thanks alot

Remove An Item In A Combobox In Vba?
do you know the method?

How Remove Item In Combobox In Vba??,
removeitem doesn't work in vba, i reach the method in vba...

Remove Garbage From Text In Combobox
I need to remove the Quotation and commas from the names I saved in a sequential file

I am getting on input to the combobox this;

"John Smith","Smith"

I want;

John Smith

This is the code I am using

Dim strFirstName As String
Dim strLastName As String
Dim strPlayerName As String
Dim FileNum As Integer
FileNum = FreeFile

strPlayerName = strFirstName & " " & strLastName
Open App.Path & "ScoutPlayers.txt" For Input As #FileNum
Do While Not EOF(FileNum)
Line Input #FileNum, strPlayerName
cmbPlayers.AddItem strPlayerName

Close #FileNum

Help please

Remove A Item Stored In A Combobox
Hi !!!

I have combobox with a lot of names and a botton, i need when a click that botton, remove the name that was selected in that combobox.


Howto Remove All Items From A Combobox
How do I remove al items from a combobox but leave the comboboxes text intact...

Also it should not create an error if there are no items in the list...

Remove Combobox's Blank Option In Msflexgrid
I have two combobox on my flexgrid, If you choose a value/option from first combo the other dropdown and showing the options, but I got a blank option, is it possible to remove it?

All help are welcome

thank you in advance

PS: All data is from DB (msSQL)

Edited by - Lars9 on 9/21/2006 10:46:49 AM

Remove Item From ListBox Or ComboBox By String

Believe me, I've looked high and low for a way to do this. I'm stumped. I have the same problem with ComboBox and ListBox.

If I .AddItem ("SomeText"), I need to remove the same item, but with just using the "SomeText" as a starting point.

The .RemoveItem only takes an Integer Index. How can I remove by String instead?



ComboBox Not Working Properly...need To Remove Read-only Property
I have a ComboBox that has the Style set to 2-Dropdown List and I'm very angry with it right now. Cause even tho I can type in a character that would match something on the list, like an a - and the word apple would appear, or b - and the word bear would appear (of course if they were in my list)...I cannot have my ComboBox make it equal to nothing because the property on it is Read-only!

So let's say I start a new order and I have all my text boxes erased with the data...I can't make my
combo box cmbList.Text = ""
Any help is appreciated!



Sum For Duplicates
I have a table in a format like

Name Task Week Revenue
Jim Typing 2 17
Jim Dashboard 2 11
Jim Dashboard 2 7
Jim Dashboard 3 5
Cathy Copying 3 4
Bobby Typing 2 11
Bobby Typing 2 6

I need to sum column4 for everything where the previous 3 records are identical

Name Task Week Revenue
Jim Typing 2 17
Jim Dashboard 2 18
Jim Dashboard 3 5
Cathy Copying 3 4
Bobby Typing 2 17

Should this be done through find dplicate query, or how ?

Does any one have a good link or easy way to find duplicates in a column (1000+ rows) ? The items that are duplicated in the column have numbers and text.


Copyright 2005-08, All rights reserved