FILL COMBO WITHOUT dupes...

Expand Post »

Admit have mymdb.mdb with table mytable and filed myfield in c:\...
Ho to fill combobox without dupes from table, please without "select distinct..." statement is possible?
Tks.

sal21

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

22 posts
since Feb 2008

Permalink

Jan 7th, 2009

Re: FILL COMBO WITHOUT dupes...

Hi,
My suggestion
> Use ORDER BY Clause
> Iterate thru all records
> If duplicate occurs (If current = previous), simply ignores it

selvaganapathy

Reputation Points: 44

Solved Threads: 101

Posting Pro

Offline

547 posts
since Feb 2008

Permalink

Jan 8th, 2009

Re: FILL COMBO WITHOUT dupes...

Hi,

Try This :

Code is easy for ListBox..
If you want To Poulate a Combo Only, Then Place a ListBox on the Form and Set it's property Visible = False

vb Syntax (Toggle Plain Text)
Dim str1 As String
RS.MoveFirst
List1.Clear
Combo1.Clear
Do While Not RS.EOF
    str1 = RS("MyField") & ""
    List1.Text = str1
    If List1.SelCount = 0 Then
       List1.AddItem str1
       Combo1.AddItem str1
    End If
    RS.MoveNext
Loop
Dim str1 As String
RS.MoveFirst
List1.Clear
Combo1.Clear
Do While Not RS.EOF
    str1 = RS("MyField") & ""
    List1.Text = str1
    If List1.SelCount = 0 Then
       List1.AddItem str1
       Combo1.AddItem str1
    End If
    RS.MoveNext
Loop

Regards
Veena

Last edited by QVeen72; Jan 8th, 2009 at 12:09 am.

QVeen72

Reputation Points: 84

Solved Threads: 140

Posting Shark

Offline

923 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: MSHFlex Grid Field get Highlighted if it is current date

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: making macro in vb6

DaniWeb Message

Cancel Changes

User Name
Password