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...
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...