List certain tables 1

[tekthis]

i have a program that i search a database and it populates a combobox with all of the tables...

is it possible for me to add only certain tables and not all of them???

the tables i want shown all have 2004 in their name...i.e. August2004, Sept2004, etc. (if this info helps)

i tired this...

If Right(Trim(cmbTables.Text), 4) = "2004" Then
Do While Not Rs.EOF
cmbTables.AddItem Rs("TABLE_NAME")
Rs.MoveNext
Loop
Else
Exit Sub
End If

when i leave the if statement off it fills the combobox with ALL of the tables...when i have it on NO tables are shown...thanks for your time...

 

[DrJavaJoe]

Try this:

Do While Not Rs.EOF
if instr(Rs("TABLE_NAME"), "2004") <> 0 then
cmbTables.AddItem Rs("TABLE_NAME")
end if
Rs.MoveNext
Loop


Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.

 

[tekthis]

perfect...thanks DrJavaJoe...heres a star...