Computer Science Canada Sorting records |
Author: | alpesh [ Tue Jan 27, 2004 10:37 pm ] |
Post subject: | Sorting records |
![]() ![]() ![]() ![]() ![]() ![]() Any body have any idea ... how to sort record in database through VB ![]() ![]() |
Author: | McKenzie [ Tue Jan 27, 2004 10:57 pm ] | ||
Post subject: | |||
1. Add ListBox, Data Contol, CommandButton 2. Attach Data control 3. Set ListBox sorted property to true
|
Author: | Acid [ Tue Jan 27, 2004 11:07 pm ] |
Post subject: | |
Well that's what I'd have suggested, if I knew just a little bit more about VB ![]() |
Author: | Tony [ Tue Jan 27, 2004 11:33 pm ] |
Post subject: | |
or if you're accessing your database using DAO method (my personal preference over DB linked elements) you can just have sort=accending/deccending in your SQL statement. |
Author: | McKenzie [ Wed Jan 28, 2004 12:05 am ] |
Post subject: | |
you can use DAO and ADO either way. MS is pushing ADO but DAO is still easier to start with. |