Return to a specific form after "time out"

  • Thread starter Thread starter Steve G.
  • Start date Start date
S

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 !
 
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
 
That worked...Thanks Gina !

Gina Whipp said:
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
Click to expand...
 
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.
 
Back
Top