Return to the user interface (login) If more than one form is opened

[zozo.zead]

Attached is a file containing a code to close Form2 if the mouse is left without moving for two minutes and the code is 100% working.
But if another form is opened, for example Form3, it does not work on it only on Form2

What is required is the code that closes all open forms, not just Form2, because I have more than 10 forms that can be opened.

[Welshgasman]

Google 'cycle through open forms access'

[zozo.zead]

Google 'cycle through open forms access'

i dont understand


I want all open forms to be closed

Whether via code (On Timer)
Or by using the ESC button, for example

[mike60smart]

The example you uploaded is not of much use.

Normally you would have a Switchboard (Main Menu)

Then when you want to close all forms you run code to Close the Forms and return the user to the Main Menu.

[davegri]

Try this code behind form2. After 2 minutes, all open forms will be closed and form1 opened.

Option Compare Database
Option Explicit
'form (module) level counter
Private mlMins As Long


Private Sub Command0_Click()
    DoCmd.OpenForm "Form3", acNormal
End Sub


Private Sub Form_Timer()
mlMins = mlMins + 1
If mlMins = 2 Then
    'DoCmd.Close
    Call CloseAllForms
    DoCmd.OpenForm "Form1", acNormal
End If
End Sub


Public Sub ResetTimer()
    Me.TimerInterval = 0
    Me.TimerInterval = 60000
    mlMins = 0
End Sub


Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    ResetTimer
End Sub


Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    ResetTimer
End Sub


Private Sub CloseAllForms()
    Dim obj As AccessObject
    For Each obj In CurrentProject.AllForms
       If obj.IsLoaded Then DoCmd.Close acForm, obj.Name
    Next
End Sub

[Micron]

duplicate thread
https://www.accessforums.net/showthread.php?t=88934

[davegri]

duplicate thread

Oops. I'm stepping on toes. Sorry about that.

[Micron]

Don't know what you mean. I was reporting a duplicate thread by the OP. Just trying to let others know about it, same as if it was cross posting.

[Bulzie]

You sure you want to auto close the forms? If they are entering data on those forms, might save incomplete records. Do they have to have multiple forms open? As someone mentioned you could have a switchboard to open 1 form at a time and then they close it to get to another form, etc.