by Michael Apel (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (3 Votes)
Advanced filtering and sorting (since v2.0) class for Microsoft Access 2000. Dynamically add and remove one or multiple filters while maintaining the current record if possible, the method used for this is faster than a FindFirst approach on ODBC connections. Prevents filters being added returning no data. RecordSource is created dynamically, no advanced SQL knowlege required.
Disable all Access-own filtering and sorting functions as they'll interfere with the class.
Import the class into your Access (library-)project.
Code contains basic usage example and further explanations.