VBA Custom Classes - Heirarchy
Posted on 2011-03-15
I'm trying to implement custom Class Modules in Microsoft Access 2003 (VBA).
I would like to build my classes such that they have what I would call "heirarchy" e.g.:
I have built the "Staff" level (clsStaff) and the "Regional Manager" level (clsRM) with a Property Get for ".Name".
I'm having unbelievable difficulty in making them line up behind the periods embedding one
inside the next. More than that, I can't seem to find example code online.
I don't know what that method of class definition is called to drive Intellisense to prompt
for the next level.
I've tried searching on:
Implements / Inherits
I think if I knew what to call it, I could follow online examples posted by others.
How do you describe what I see in VBA all the time with Automation? Multiple levels
of classes period after period after period:
I am not trying to create these levels with Custom Collections. They are single pieces of info
with increasing specificity at each level.
Sorry. I know my question is inelegant, but I'm pretty good with VBA and this one has me stumped because I can't even look up an example.