A Microsoft Access tool to automatically rename your form controls

I love Microsoft Access. There, I said it. Thare are so many things I love about it that I wouldn't know where to start with listing them all. So, it's just as well that this article isn't about that. It's about fixing one of those things that's just a bit of a pain. Use prefixes [...]

The InputBox Function, the InputBox method, and using strptr

The InputBox is one of the most commonly called functions in the whole of VBA. Whether you're writing a complete database application in Microsoft Access, or just adding bit of functionality to your Microsoft Excel workbooks, the odds are that you won't do much coding before you make your first call to the InputBox function.

So, I thought I'd dedicate this post to getting a little more from the InputBox - particularly in Excel, but also in Access.

Microsoft Access VBA – object variables

Early binding versus late binding in VBA

When you create object variables - that is, variables that refer to an object, such as an ADO recordset, or Microsoft Excel, rather than a data type such as Integer - there are two ways in which it can be done: through early binding or through late binding.

In this blog post, we take a look at what the differences are between early and late binding, when you might use each, and what that difference that decision makes for your code.