Class Modules 1

[nickjar2]

I have created several functions/methods in a Acc 2000 db, and was hoping I could store all code that could be reused, in this db. I was then gonna place this db in a shared area. I would then have a db with several resusable Classes
When i come to create a new db, i was hoping to goto the Tools References, and point to this 'Class' db, and use the 'OO' capabilities of Acc. Then I thought I could refernce this 'Class' db with the New keyword, and access all the methods/properties. No such luck.
Am i doing something wrong, or is it not possible to access a class module from outside the database where the class module exists? If that is the case, seems a bit pointless really. Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[nickjar2]

Ed,

Your post hasn't appeared for some reason.

Cheers! Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[Craig0201]

Nick,

The classes need to be moved to a VB ActiveX dll project and compiled. This can then be referenced the same as any other class library.

Craig

 

[nickjar2]

I thought maybe that was the case. A bit of a pain if, like me, u only have Office and not VB. Cheers 4 that. Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)