Shamil Salakhetdinov
shamil at users.mns.ru
Wed Dec 12 14:01:52 CST 2007
Charlotte, It doesn't matter that much - just to be precise: That could have been my article published in Smart Access - this one: http://smsconsulting.spb.ru/shamil_s/articles/deep4sa.htm AFAIK Ken Getz didn't publish anything in Smart Access and other public sources on that subject before referred above article was published... Deborah Kurata did write on WithEvents related to VB6 before my article was published but I was unaware of that publication... The trick with setting [Event Procedure] dynamically was original idea presented in the referred above article... Just to be precise the idea of this "trick" was "hinted" to me by Marek Kepinski in summer 1998 in Access-L - I was aware of WithEvents but I wasn't aware how to use it and Marek showed me a static sample code, which I then found how to convert to dynamic setting of [Event Procedure] property. BTW, that isn't straightforward when you doing such things first time - quite some time and "dirty" and sometimes heavy work is needed and then finally you see what you were hunting for... Everything is easy then... It doesn't matter that much - just to be precise with facts as they appeared in chronological order... Thanks. -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, December 12, 2007 8:56 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Classes In Referenced MDE You're right, Jim, and I'm sure that's where I got it. Charlotte -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Wednesday, December 12, 2007 8:34 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Classes In Referenced MDE Ken Getz published an article on this long ago. Believe it was in Smart Access. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, December 12, 2007 11:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Classes In Referenced MDE Andy, There's nothing illegal about modifying a class that way. It even lived in Microsoft's own help files way back when in earlier Access versions. I think I first used it in 97 after I had found Shamil's DEEP article, but I don't think I got the technique from him. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Wednesday, December 12, 2007 6:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Classes In Referenced MDE 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com