Shamil Salakhetdinov
shamil at users.mns.ru
Wed Dec 12 07:47:40 CST 2007
Hello Andy, Yes, this Add-in is needed on development PC only: it does "a once-and-for-all change" for referenced *MDB*. Then you have to compile this MDB into MDE as usual. And then it will work ok for MDE. Please make back-up copy of your program MDBs before running this add-in if you will decide to use it. <<< Not sure if my bosses (client) will let me use it though - will have to approach it gently. >>> That's up to you and your bosses to decide I have my disclaimer published with this add-in. I can say that it's almost 10 years now as this add-in was published and it was used by several of my partners/customers - and it always worked OK. But once again - always make backups before running this add-in for your program databases.... -- 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 2:24 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Classes In Referenced MDE Whoa, amazing stuff as ever from you Shamil. Not sure if my bosses (client) will let me use it though - will have to approach it gently. I've got two questions. Firstly will it work on an MDE? Secondly am I right in thinking that the Add-In would only be needed on the development machine because it does a once-and-for-all change to the referenced MDB/MDE? So once the add-in has done its work if the Fe and MDE are then copied down to a user's machine will everything run ok without the user needing the Add-In? -- 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 12:14 Hello Andy, No legal way with Access 97... "not legal" but used by several developers and worked well for them - here it's: http://smsconsulting.spb.ru/shamil_s/articles/cexposer.htm Please take into account that if you use VSS then it will clear the flags which can be set by the referred above add-in.... 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 1:42 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Classes In Referenced MDE 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com