I'm busy with a VBA application in Excel. I have a combobox on a form that where I have a to display a list of codes that comes from 2 tables in a database. I load the lists seperately into the combo box, but how do i sort it afterwards? I can't seem to find something that says: ComboBox1.Sort ascending...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting Combo Box
- Thread starter melvt69
- Start date
- Thread starter
- #3
well, the tables are sorted. Let me try an example for you to understand:
table 1: koos, john, piet.
table 2: candy, mel.
now i load table 1 in the combo and then table 2 in the SAME combo. I end up with:
koos
john
piet
candy
mel
What i want is:
candy
john
koos
mel
piet.
table 1: koos, john, piet.
table 2: candy, mel.
now i load table 1 in the combo and then table 2 in the SAME combo. I end up with:
koos
john
piet
candy
mel
What i want is:
candy
john
koos
mel
piet.
Well, there is no sort option for a combo box
What kind of database are you pulling your data from ??
Can you not just make a simple query to create a new table which is the 2 tables combined and sort that ??
Other than that, you'd be into code to read recorsets or some complex looping through an array of strings.. Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
What kind of database are you pulling your data from ??
Can you not just make a simple query to create a new table which is the 2 tables combined and sort that ??
Other than that, you'd be into code to read recorsets or some complex looping through an array of strings.. Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
- Thread starter
- #5
It's a SQL database. I link it in Access to create queries, etc.
U c, it's 2 different fields. I have normal codes and then a group which these codes belong too.
Eg.
table 1: john, adrian, mel.
table 2: male, female. (Groups)
I have to have them all in one combo box.
U c, it's 2 different fields. I have normal codes and then a group which these codes belong too.
Eg.
table 1: john, adrian, mel.
table 2: male, female. (Groups)
I have to have them all in one combo box.
- Thread starter
- #7
Sorry I don't understand - in your 1st example you had:
table 1: koos, john, piet.
table 2: candy, mel.
now you are saying it is:
table 1: john, adrian, mel.
table 2: male, female.
1st you wanted
candy
john
koos
mel
piet.
Now you want
adrian
female
john
male
mel
I am confused ?!?
How does the male / female indicator fit into an alphabetised list of names ??
Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
table 1: koos, john, piet.
table 2: candy, mel.
now you are saying it is:
table 1: john, adrian, mel.
table 2: male, female.
1st you wanted
candy
john
koos
mel
piet.
Now you want
adrian
female
john
male
mel
I am confused ?!?
How does the male / female indicator fit into an alphabetised list of names ??
Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
- Thread starter
- #9
But where do the codes come into it if you just want a list of all names held in the 2 tables ??
Surely, you just need to do a MT query to get all names from 1st table on their own and then an append query to add the names from the 2nd table ?? Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Surely, you just need to do a MT query to get all names from 1st table on their own and then an append query to add the names from the 2nd table ?? Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
- Thread starter
- #11
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question