Advanced Access VBA Class Module Examples
Posted on 2014-01-24
I would like to begin to use Class modules in Access 2010 VBA and have looked at simple examples in several Access VBA books and at online sites. Most of the Class Module examples that I've found are trivial and don't seem to help me understand how I could use classes. What I haven't found are more advanced examples. I definitely want to create collections for several of my objects. For example, there are 8 different Funds each with different rules for collecting fees, with different start and end dates. A collection of Funds would be a big help to me when calculating Management fees for a specific period.
I would love to see a real world example of using classes for the type of challenges anyone would encounter.
Can anyone point me to a book or online site that has class module examples more complex than adding 1 to the number of students in a class and then building a function to retrieve it?
Over the past 5 years I have created applications to track investments, report on dozens of financial metrics, produce Investor Quarterly Reports/Graphs, and built interfaces with accounting and loan servicing systems for a private equity firm. There have been a lot of very complex and challenging programs developed in MS Access with a MS SQL Server database. I want to make the code easier to maintain and to minimize complexity by using classes.