Adding time on a form

  • Thread starter Thread starter Armele
  • Start date Start date
A

Armele

Hi,

I would like a form to be closed if there is no activity after 5 minutes.
How do I code it?
 
Dale_Fye,

Thanks for the message. However, after following the steps, when I tried to
open the form, I get the following error:
The expression on timer you entered in the event property setting produced
the following error: User defined typed not declared.

Do I need to check off any thing in the reference library, if so, what?

Thanks
 
I am still getting the same error.

Dale_Fye via AccessMonster.com said:
My guess is that you did not put the declaration of dtLastActivity in the
forms declarations section.

When you open that forms code, go to the very top. You should see something
like:

Option Compare Database
Option Explicit

Does not have to include both of these but I always include the Option
Explicit line.

Right below that, declare the dtLastActivity variable as DateTime, like:

Private dtLastActivity as Date

Below that, you should see the code for your various form and control events.

Dale
Dale_Fye,

Thanks for the message. However, after following the steps, when I tried to
open the form, I get the following error:
The expression on timer you entered in the event property setting produced
the following error: User defined typed not declared.

Do I need to check off any thing in the reference library, if so, what?

Thanks
It depends on how you define no activity. Personally, I consider no activity
to mean that no information has been entered in the form, that the cursor has
[quoted text clipped - 48 lines]
I would like a form to be closed if there is no activity after 5 minutes.
How do I code it?

--
HTH

Dale Fye

Message posted via AccessMonster.com
 
Back
Top