Sort in data access

June 16, 2010 at 00:49:03
Specs: Windows XP
I created an data access page. I used wizard provided in MS Access.

Next, I added a drop down menu. I want to be able to sort data in the access page using the options in the drop down menu.
To do this, I added a OnChange="sortby(this)" event in the select using javascript. And then created a function in the header.
The function trigger when I select the option from the drop down but I just down how to go about sorting the data.


See More: Sort in data access

Report •

#1
June 22, 2010 at 00:18:58
I figured it out after hours of google-ing.

MSODSC.DataPages(0).Recordset

Creates a recordset to the table. Then to sort the table,
I used,

MSODSC.DataPages(0).Recordset.Sort = "CarID ASC";
This sorted the table in ascending order using CarID field.


Report •
Related Solutions


Ask Question