[AccessD] sorting a list

Susan Harkins harkins at iglou.com
Mon Apr 21 20:03:04 CDT 2003


Can't use a query -- I'm using a For Each to loop through a collection to
get the list. I thought about filling a table with the list, but that seems
worst than sorting an array. Wonder which would be quicker?

Susan H.


> I'd say the easiest way is to switch it to a query, put the 'list' in a
> table, and have the query sort it! <grin>
>
> If you must stick with a list, use split to put it into array, then dump
it
> into a collection (or just resort the array).  Then rebuild the string.
Of
> course I think this is a long way of doing things!
>
> Drew
>
> -----Original Message-----
> From: Susan Harkins [mailto:harkins at iglou.com]
> Sent: Monday, April 21, 2003 7:52 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] sorting a list
>
>
> Anyone have an easy way to sort a list or combo control's list when
working
> with a Value List RowSourceType?
>
> Susan H.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>



More information about the AccessD mailing list