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
Videos
Objects, Properties and Methods
Referencing Properties
Related Posts
01 – The VBA Editor03 – 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