Unanswered: Adding "Select All" Option in the combo box
How could we add "Select All" option in the combo box. As we could do in access as
SELECT DISTINCT Type.description,Type.description FROM Type UNION Select "(All)" as Bogus, "*" as AllChoice From Type
ORDER BY Type.description;
But in sql server how could we hv the same functionality????
SELECT DISTINCT Type.description,Type.description FROM Type UNION Select "(All)" as Bogus, "*" as AllChoice From Type ORDER BY Type.description;
and its running in access.... Good..and also access code is working fine.
now after conversion in sql server, the combo box that is associated to this query is populating with the data as in access but the only thing missing is the option "ALL" and that would be default and first option for the combo box...Its not coming and i hv code in vb that is running according to "ALL" and '*' options....
and there is not any parameters coming from out side.....
So cud that be solved.
Actually our company has upsized its Access database to sql server. Now there are certain thing that upsizing wizards dont do. So that things needs to be fixed. Now having backend in sql server and front end in access i was having trouble in populating the combo box with (ALL) word in the combo box.and above query that "r937" told me is pretty help ful at least now i can have this key word. now i m gonna take a look on its functionality...
Thx all of you.