Archive Collection: Nothing

From September 1, 2020, through April 27, 2024, I posted an article here every single day.  Beginning on April 28, 2024, I started slacking by taking off Sundays.  So, while my daily streak has been broken, I still have an automated weekly email that goes out every Sunday morning and includes details of the last six articles I've posted. (You should sign up for it if you haven't already; just hit the [Subscribe] button above.)

In other words, I still need to post a new article every Monday through Saturday or my weekly email doesn't work right.  I'm currently on vacation, though, which makes maintaining this streak a bit...tricky.

I don't want to be writing and publishing articles on vacation.  And I still want to provide you with something of value to read each day.  So I settled on creating a series of curated article lists that I think you'll find beneficial.

I'm hoping at least some of these articles are ones you haven't read before.  And if you're so obsessed with me that you have read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.  

Enjoy!

The Many Forms of Nothing in VBA

An Article About Nothing

This one’s for the nihilists. We explore the many ways to express the concept of nothingness in VBA.

No Longer SetMike Wolfe

Much Ado About Nothing

An in-depth look at the Nothing keyword in VBA: when you need it; when you don’t; and one technique to avoid it altogether.

No Longer SetMike Wolfe

Working with Null in Microsoft Access

Let’s explore the many ways to check for, handle, and store Null values. Spoiler alert: the best way to do it varies between VBA and SQL.

No Longer SetMike Wolfe

The vbNullString Constant in VBA

What is the vbNullString constant in VBA and how does it differ from a simple empty string (”″)?

No Longer SetMike Wolfe

The vbNullChar Constant in VBA

What is the vbNullChar constant in VBA and how does it differ from vbNullString?

No Longer SetMike Wolfe

Working with Empty in VBA

A deep dive into the Empty keyword in VBA: why it exists, how to check for it, when it makes sense to check for it, and--most importantly--how NOT to check for it.

No Longer SetMike Wolfe

The Missing Keyword in VBA

Wondering what the IsMissing() function is all about in VBA? We’ll explore that plus all the ins and outs of the VBA keyword that isn’t: Missing.

No Longer SetMike Wolfe