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.
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.
B-BEAR: Quick and Dirty SQL Server Testing
Begin, Before, Execute, After, Rollback. This technique makes testing your SQL Server statements a snap.
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