[AccessD] Shutting down applications if they are not being us ed

Drew,

May I suggest that you put your web site in your sig?  I don't know how to
get to your site to get this thing.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
DWUTKA at marlow.com
Sent: Saturday, February 21, 2004 4:08 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Shutting down applications if they are not being
us ed


Just put Inactivity2k on my website.  In Access 97, AddressOf is not a
supported function, but Ken Getz wrote a function, AddrOf, where he hacked
into the VBA .dll, in order to simulate VB's AddressOf capability.
(AddressOf is required for callback functions).

Apparently, AddressOf IS supported in A2k (and up).  However, this is a BIG
BIG BIG BIG BIG warning from Microsoft.  (and their right, at least for
A2k).  Use this code ONLY in your final products, because if the VBE editor
has been opened, the callback capability goes bezerk, and sends the VBE into
an endless loop, which makes Access look like it has locked up.

Drew