Printable View
I've created my own customer browser application but would like to apply a sort button on it. I can't seem to find any help on how to sort the database. Can you recommend a link?
By the way you have the best tutorial I've ever seen and I've been thru a lot in the past year. Keep up the good work.
Are you using DAO or ADO? Are you using SQL statements to get your data?
Whichever method you use to access your database, you have basically two ways to sort the data.
One way is while retrieving records into the recordset you can frame the query with an 'Order By' clause to have the records sorted before they are sent to the recordset.
Another way is if you already have a recordset, use its .Sort method to sort the records in the recordset.
The first method is useful if you don't need to re-sort your data again and again. But if you are allowing the user to select and later change the order of sorting I believe you are better off with the second method.