Andy Lacey
andy at minstersystems.co.uk
Wed Dec 12 08:44:35 CST 2007
Only wish I knew what any of that meant Shamil. :-( It's looking fine as is now anyway. If what I've done isn't legal I'm relying on you all to keep schtum. :-) -- 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 14:59 Andy, Just wanted to note that another legal option could be to move your code into VB6 ActiveX dlls... ....or even into VB.NET COM-exposed classlibs in the case your customers' PCs do have .NET framework installed... ....for the latter case there could be (quite some) overhead while getting through CCW (COM Callable Wrappers generated by TLBEXP) and therefore for the often used library functions moving code to VB.NET classlib(s) could become inefficient.... -- 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 -- 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