Advanced Filter Class v2.0
Michael Apel
(1 Submission)
Databases/Data Access/DAO/ADO
Visual Basic 5.0
Intermediate
Wed 3rd February 2021
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.
Rate Advanced Filter Class v2.0
(4(4 Vote))
(4(4 Vote))
Download Advanced Filter Class v2.0
Active Server Pages
Coding Standards
Complete Applications
Custom Controls
Data Structures
Databases / ADO
DDE
Debugging & Errors
DirectX
Encryption
Files / I/O
Games
Graphics
Internet / HTML
Jokes / Humor
Libraries
Math / Dates
Office / VBA
Miscellaneous
OOP
OLE / COM / ActiveX
Registry
Sound / MP3
String Manipulation
VB Enhancements
Windows API
Windows CE
System Services