I opened a recordset (rs) with DAO connection like this:
'get data source
Set db = OpenDatabase("C:\aDatabase.mdb")
'open access table
Set rs = db.OpenRecordset("aTableName", dbOpenTable)
let say I have 10 fields in each record in the table "aTableName" and one of them is called "aName". How can I sort all the records in rs by the field "aName"?
Thanks in advance!