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.

Why use a database?

What is the point of Microsoft Access?!

Most people who have Microsoft Office use Word, and very many use Excel. Some use PowerPoint, and a good proportion use Outlook.

But comparitively few people use Microsoft Access. So why is that? Partly because it's not perhaps as simple to use as the other applications, and so lots of people don't know how to use it.

So, why not learn? Perhaps because a lot of people don't see the point. So, in this post, we take a look at exactly why people do use Access - and why you might want to.