Andy Lacey
andy at minstersystems.co.uk
Wed Dec 12 04:41:53 CST 2007
Hi Shamil Thanks for this. Sounds like what I need except that I can't see how to set the PublicNotCreatable property. Can you talk me through that? And before we go any further I'd better admit this is A97 in case that blows this. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Classes In Referenced MDE Date: 12/12/07 11:32 Hello Andy, This is a feature by design: you cannot have Creatable custom classes in a library MDB/MDE. Although you can have PublicNotCreatable custom classes (you can set this property via custom class's properties window in VBA IDE, default value is private) in your library MDB/MDE: they will be visible in FE but you can't use New keyword to create their instances in FE - the hint/"trick" is to use helper functions to create instances of these classes in library MDB/MDE.... There are also "dirty" tricks to make custom classes in MDB/MDE creatable using New keyword in FE but I'd not recommend using them and therefore I'd not write more on them here... HTH... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Wednesday, December 12, 2007 12:49 PM To: Dba Subject: [AccessD] Classes In Referenced MDE Hi all I've been experimenting with creating a library of standard functions in anticipation of a new project. Created MDB, imported modules with standard functions, created MDE from that and then referenced that MDE in my FE. All fine and dandy. Then imported into my library a class module. Recreated MDE. This time though my FE fails to compile because it doesn't like my Dim of a new instance of the class - unknown user-defined type. Question is am I doing something wrong or is this a limitation, ie that class modules must reside in the FE from which they're called. One of you class experts is sure to know this one. -- Andy Lacey http://www.minstersystems.co.uk ________________________________________________ Message sent using UebiMiau 2.7.2 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2