Would you like to give your users the ability to sort fields in Ascending and Descending order at the click of a button?
This MS Access sample demonstrates how you can easily add such functionality to any continuous form. The code provided is adaptive and reusable. All you need to do is import a standard module into your database, add the required sorting controls and add some code to each form’s Open event which will automatically do the rest.
There is no code required for each button.
The Sorting Function is adaptive to as many sorting buttons you require as long as you follow the naming convention provided in the sample database.
You may change the button appearance as you see fit; add your own images, etc… all that matters is their names.
The nature of the sorting function is that is will sort the fields in the order the sorts are added to the form. So it will retain the order of the fields you sorted even if your change the sort type on a given field.
You are also presented with a button to clear each individual sort.
Quick, Easy, Reusable!
Take it for a Test Drive
You can download an accde version to try out by using the following link.
Purchase MS Access Continuous Form Dynamic Sorting
MS Access Continuous Form Dynamic Sorting – Version 1.00 (accdb x32bit database format)
If you do not have Microsoft Access, simply download and install the freely available runtime version:
Although we have taken steps to ensure that the software on this site is free of viruses, we provide the software ‘AS IS’ and we recommend you take the time to scan it again.
In no event will CARDA Consultants Inc. be liable to the client or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.