02 – Objects, Properties and Methods

In this post, we will be looking at objects, properties and methods in VBA.

VBA is an object based language and can interact seamlessly with Access objects (along with objects from other Office programs such as Excel and Word). In the physical world objects are things like tables, cars and people and in the VBA world objects are things like Tables, Queries, Forms, Reports, RecordSets, Buttons, Combo-Boxes, List-Boxes, Text-Boxes, Charts, etc.
The secret to programming with an object based language is to understand how to manipulate these objects by taking advantage of their properties and methods...

List of topics covered:

  • Objects, Properties and Methods
  • Objects
  • Properties
  • Methods
  • The Recordset object
  • Collections
  • Objects, Properties and Methods – An Analogy
  • Programming with Objects

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!