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

Downloadable Content

Code Examples VBA Fundamentals

PDF

Videos

Objects, Properties and Methods

Referencing Properties

Related Posts

01 – The VBA Editor
03 – Data Types, Variables, Constants and Operators
04 – Events
05 – Functions, Sub-procedures And Arguments
06 – Debugging
07 – Conditionals And Branching
08 – Arrays And Collections
09 – Loops
10 – Recordsets

Leave a Reply

Your email address will not be published. Required fields are marked *

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube