I'm maintaining a MS Access 2000 application. I'm accustomed to languages (e.g. Python) that provide thorough Object Oriented Programming support, and I struggle with the very limited Object Oriented Programming support in VBA. I'm wondering whether you have any suggestions regarding mapping Object Oriented Programming concepts to VBA. It seems to me that there is so much that I just can't do, and a little that I can do that requries writing much more code than I'd use in Python.
It amazes me that MS has provided such a limited oop model!