Form close automatically after certain amount of time 1

[cmmd2003]

IS there a way of making a form close automatically after a period of inactivity.

 

[TheAceMan1]

How are ya cmmd2003 . . .

Have a look at the forms [blue]On Timer[/blue] and [blue]Timer Interval[/blue] events!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[cmmd2003]

Thanks for all your help.
Your a wiseman.
That made sense, but is there a way i can set it so that if the computer has been left in the same state for, lets jus say 30 seconds, then something happens.

 

[TheAceMan1]

cmmd2003 . . .

What have you tried? . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[cmmd2003]

I havent tried anything apart from using the timer interval. But that just runs the DoCmd consistently over an interval

 

[TheAceMan1]

cmmd2003 . . .

Roger That!

[blue] . . . but is there a way i can set it so that [purple]if the computer has been left in the same state[/purple] for, lets jus say 30 seconds, then something happens.[/blue]

If we define [blue]the same state[/blue] as [purple]no keyboard activity[/purple] (as far as the user interface is concerned), perform the following:
[ol][li] in form design view, set the forms [blue]Key Preview[/blue] event to [purple]Yes[/purple].[/li]
[li]In the forms [blue]On Key Down[/blue] event, copy/paste the following:

[blue]   Me.TimerInterval = 30000[/blue]

[purple]This resets the timer on each keypress[/purple]. If no keypress for 30 seconds the [blue]On Timer[/blue] event is executed.[/li]
[li]Enter the code you want to execute in the forms [blue]On Timer[/blue] event. Before doing so (for test purposes), enter the following line:

[blue]   MsgBox "Time Is Up!"[/blue]

[/li]
[li]Perform your testing . . .[/li]
[li]When satisified enter your code in the [blue]On Timer[/blue] event.[/li]
[li]Done![/li][/ol]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[cmmd2003]

Nothing seems to happen. The Timer Interval event is left at 0. Not sure if that makes any differnce

 

[TheAceMan1]

cmmd2003 . . .

Woops! . . . forgot to start the car!

The same line you entered in the forms [blue]On Key Down[/blue] event, enter in the [blue]On Load[/blue] event.

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[cmmd2003]

Thanks.. your a legend.
Would it work the same with On Mouse Move

 

[TheAceMan1]

[blue]No reason why not! . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886