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:

February 06, 2025 6:30 pm - 7:30 pm

View Event Join Meeting