VBA classes in referenced mdb's or accdb's
Is there a way round the following?
You can have classes in a referenced mdb or accdb file (Tools > References) and you can use them in a normal way within that referenced db (i.e. you can declare variables as instances of such a class). But you can't use them in any normal kind of way from the VBA code in the calling access database (i.e. you CANNOT declare variables as instances of such a class, and neither will Intellisense work).
This is a severe shortcoming in programming with classes in VBA. Has anyone found a way round it?
|