|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
RowSource - 6/29/2006 0:21:55
Hi,
I create the the combox in the form.
The Enter Event of the combox is
name.rowsource = "(select 'ALL' From [tbl]) Union (select [Name] from [tbl] Group By [Name] Order By [Name])"
The list solutions are:
Alan
ALL
Amy
Jeff
....
...
Can I put "ALL" in the first postion?
ALL
Alex
Amy
....
Because "ALL" means all the values.
I want to put "ALL" in the first place.
Thanks.
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: RowSource - 6/29/2006 9:38:15
quote:
Because "ALL" means all the values.
I want to put "ALL" in the first place.
I sometimes cheat and put a space in front of the 'a' and that frequently will be a good shortcut. However, be aware that using "trim" and other types of functions may make it not work.
The other way is to not list ALL in the query but 'hardcode' it as the first item in the list by writing it before you do the loop to write the options.
That make any sense?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
