Advanced Combo Box Techniques

Today I gave my presentation on implementing Advanced Combo Box Techniques to the Eastern Time Access Users Group.  Former Access MVP Dale Fye (a fellow member of the Long Gray Line!) was my gracious host.

Resources

Slide deck

Here's a PDF copy of the slides:

• ComboBoxapalooza: Advanced Combo Box Techniques

Sample database

Here's a copy of the sample database from my demo:

• ComboBoxapalooza.accdb

WithEvents introductory presentation

As promised in the meeting, here is a link to my last presentation:

ArrowKeyNav Presentation

A list of resources and further reading to support my presentation on Navigating Continuous Forms using WithEvents.

No Longer SetMike Wolfe

Video link

The lovely and generous Crystal (@strive4peace123) edited the video and posted it within the Access User Group series on YouTube.  This is a much better version than the raw video I uploaded shortly after the event, as it includes a time-stamped table of contents and links to additional resources in the video's description.

The raw video recording is available on YouTube:

Further reading

Below is a sampling of my articles that go more in depth into some of the topics I mentioned during my talk:

Combo Boxes - No Longer Set

Take your combo boxes to the next level with advanced techniques like cascading, lazy loading, and multi-column progressive filtering.

No Longer SetMike Wolfe

Python-inspired Doc Tests in VBA

Doc tests are not a replacement for unit or integration testing. But they do provide the best return on investment (ROI) of any type of test, mostly because the effort to write them is near zero.

No Longer SetMike Wolfe

The One Function Every VBA Developer Needs in a WithEvents Class

Your WithEvents event handlers will only run if you set the event property to ”[Event Procedure].” Here’s a safe and easy way to do that.

No Longer SetMike Wolfe

Throwing Errors in VBA

Introducing a frictionless alternative to Err.Raise.

No Longer SetMike Wolfe

JetShowPlan: A Primer

You may be familiar with JetShowPlan, but I guarantee you’ve never read an article about it quite like this one.

No Longer SetMike Wolfe

UPDATE [2021-07-23]: I added a link to the presentation video on YouTube.

UPDATE [2021-07-31]: I added a link to the edited Access User Group video on YouTube.