Using VBA Classes to Standardize Form and List Filtering with Eric Blomquist

Please join us for our Monthly Chapter Presentation on May 4th, at 6:30PM Pacific (UTC -8)
(Please verify your Time Zone offset.)

What do you do when you can’t find third-party software tools to accomplish tasks you need to get done quickly and without hassle? Eric Blomquist decided to just create his own tools using VBA classes.

Eric’s business, advising large institutional investors concerning high finance and private equity in particular, requires being able to track and manage large amounts of interrelated data quickly and efficiently.  The result of his effort to create Access-based tools to support his business includes a standard object framework using VBA classes and a rigorous naming convention.

We’ll get the benefit of seeing one of those tools in action in this presentation.  Specifically, Eric will demonstrate how this framework enables the methods he depends on every day, including form and combo box list filtering and navigation.  He’ll also share some of his findings about undocumented object behavior that enables some of this operation.

Please join us to see how the secret sauce is created.

Picture of Secret Sauce
VBA Classes are the Secret Sauce of Efficient Filtering and Sorting







Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.

Add AUG Pacific meeting to your_Outlook Calender


Please prepare ahead of time by downloading Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:

When it’s time, join the meeting from here:

Join Zoom Meeting

If you are asked:

Meeting ID: 861 2395 1916
Passcode: AUG_AP1!

Dial by your location
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
Meeting ID: 861 2395 1916
Passcode: AUG_AP1!
Find your local number: