How would I determine the amount of (Windows) idle time elapsed in Office
Access 2003 and then call or trigger an event.
i.e. If the current user has not used their mouse or keyboard for 15
minutes, the database will close.

Please help...

The technique described in http://support.microsoft.com/?id=128814 should
work in Access 2003 as well.

"Martin Lloyd" wrote:

> How would I determine the amount of (Windows) idle time elapsed in Office
> Access 2003 and then call or trigger an event.
> i.e. If the current user has not used their mouse or keyboard for 15
> minutes, the database will close.
>
> Please help...

Doug,

That will get idle time in Access, but the question sounded more like idle
time within Windows. I had the impression that if Access was open in the
background but the user was doing something else that the time shouldn't
show as idle. For that, you would need to get a hold of the timer used for
the screen saver or some other timer within Windows. I suspect it would be
an API call to either get this value or create your own timer within
Windows, but looking through the API list, I didn't see it; however, I'm
perfectly willing to admit that I may have just browsed past it.

--
Wayne Morgan
MS Access MVP


"Doug Steele" <(E-Mail Removed)> wrote in message
news:0A1E2DEC-EFAC-40FE-9C31-(E-Mail Removed)...
> The technique described in http://support.microsoft.com/?id=128814 should
> work in Access 2003 as well.
>
> "Martin Lloyd" wrote:
>
>> How would I determine the amount of (Windows) idle time elapsed in Office
>> Access 2003 and then call or trigger an event.
>> i.e. If the current user has not used their mouse or keyboard for 15
>> minutes, the database will close.
>>
>> Please help...