Throwback Thursday: October 3, 2024

With over a million words scattered across more than 1,300 articles on this blog, you've probably missed a few things here.

That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.

Highlights from NoLongerSet.com

A Safe Way to Add Temporary Code

A quick tip to ensure your temporary code disappears when the sun sets.

No Longer SetMike Wolfe

The Extra Resume

Want an easy way to jump to the line that raised the error AND avoid the infinite loop time bomb? Add an extra Resume.

No Longer SetMike Wolfe

B-BEAR: Quick and Dirty SQL Server Testing

Begin, Before, Execute, After, Rollback. This technique makes testing your SQL Server statements a snap.

No Longer SetMike Wolfe

Wisdom from Around the Web

I can't take credit for the "Extra Resume." I learned that one from Access MVP Armen Stein:

Developer Humor

Why use the "Extra Resume" in the first place? To avoid infinite loops in your VBA error handling.

It's a great technique to share with your colleagues and fellow VBA developers.

...

Or not...

...

Cover image generated by Ideogram