[AccessD] Classes In Referenced MDE

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




More information about the AccessD mailing list