Return to a specific form after "time out"

[Steve G.]

I followed article 210297 on 'HOW TO: Detect User Idle Time or Inactivity in
Access 2000' and it works fine, however, instead of closing the access
application entirely, I need to return to a specific form. Can anyone help me
with a solution ? Thanks ahead of time !

 

[Gina Whipp]

Steve,

Instead of...

Sub IdleTimeDetected (ExpiredMinutes)
Application.Quit acSaveYes
End Sub

Try...


Sub IdleTimeDetected (ExpiredMinutes)
DoCmd.OpenForm "NameOfYourForm"
End Sub

If you want it to open to a specific record you will have to add some
parameters.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Steve G.]

That worked...Thanks Gina !

Steve,

Instead of...

Sub IdleTimeDetected (ExpiredMinutes)
Application.Quit acSaveYes
End Sub

Try...


Sub IdleTimeDetected (ExpiredMinutes)
DoCmd.OpenForm "NameOfYourForm"
End Sub

If you want it to open to a specific record you will have to add some
parameters.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

You're welcome...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Steve G.]

Gina,
Hello Again !
The OpenForm command worked great, but I noticed I still have opened forms.
Is there code that will allow me to close all open forms and then return
control to my Startup Screen ?
Steve G.