VBA: Class Modules

[Randomblink]

I have been coding in Access since 95, but I stepped away from Access and learned the OOP concept in languages like PHP and Javascript... Now I would like to apply the concept to Access db's I am working on. Does someone know of a good online site for learning VBA OOP??? Help if you can... thanks!

 

[MarkK]

I recently wrote an Access system using an OOP approach and had difficulty finding reference material as well, but my observation now is you might not need it. VBA doesn't support inheritance, so you can't override, overload, or shadow members in a base class. This being the case, if you know VBA, you know all you need to know.
You can spoof inheritance to good effect by exposing a 'base' class as a property in a 'derived' class. It adds an extra qualification step when you refer to it, like: clsDerived.clsBase.baseMember -vs- clsDerived.baseMember, but it works.
Post back if want more info, since I think this is a super cool way to go, particulary if you want to drive tree views and stuff.