How is it possible in VB5 Prof. to sort an Access database?
I want to sort the database using any header. If several are the same
the next key should be used.
Please als reply per email
Thanks in advance
You can apply a sort property to dynaset and snapshot type. Using this
property will set the sort order for subsequent instance of the recordset.
Set myRS = myDB.OpenRecordset("TableName", dbOpenDynaset)
myRS.Sort = "FieldName"
Set mySortedRS = myRS.OpenRecordset()
The same concept apply to Filter property.
John Rychter, MCSD
Quote:>How is it possible in VB5 Prof. to sort an Access database?
>I want to sort the database using any header. If several are the same
>the next key should be used.
>Please als reply per email
>Thanks in advance
Anyone try to sort a column with hyphen & alphabets mixed in the data ??
Why the hyphen("-") is treated to be of higher order in RS.SORT whilst its
ASCII order is lower than the alphabets ?? Is it a BUG ??!!
6. good books?
11. Sort not sorting