close access application aftera specific time

mana

Registered User.
Local time
Yesterday, 19:09
Joined
Nov 4, 2014
Messages
265
Hello,

i have an access application and i wnat that aftera specific time it would be closed automatically. I found the following code in timer event of a form that is hidden. but it takes long and i want that it works sooner than that. do you know where should i change the time?

i also have one other question. some pdf files will be opened from hyperlink of my app and when the app will be closed the pdf files are still open, is there a way that i can close all of the pdfs as well?

thank you for your help

Code:
Private Sub Form_Timer()
' IDLEMINUTES determines how much idle time to wait for before
         ' running the IdleTimeDetected subroutine.
        Const IDLEMINUTES = 1
         Static PrevControlName As String
        Static PrevFormName As String
         Static ExpiredTime
         Dim ActiveFormName As String
         Dim ActiveControlName As String
         Dim ExpiredMinutes
         On Error Resume Next
         
         ' Get the active form and control name.
        ActiveFormName = Screen.ActiveForm.Name
         If Err Then
            ActiveFormName = "No Active Form"
            Err = 0
        End If
         ActiveControlName = Screen.ActiveControl.Name
            If Err Then
            ActiveControlName = "No Active Control"
            Err = 0
         End If
         ' Record the current active names and reset ExpiredTime if:
         '    1. They have not been recorded yet (code is running
         '       for the first time).
         '    2. The previous names are different than the current ones
         '       (the user has done something different during the timer
         '        interval).
         If (PrevControlName = "") Or (PrevFormName = "") Or (ActiveFormName <> PrevFormName) Or (ActiveControlName <> PrevControlName) Then
            PrevControlName = ActiveControlName
            PrevFormName = ActiveFormName
           ExpiredTime = 0
        Else
            ' ...otherwise the user was idle during the time interval, so
            ' increment the total expired time.
           ExpiredTime = ExpiredTime + Me.TimerInterval
         End If
         ' Does the total expired time exceed the IDLEMINUTES?
         ExpiredMinutes = (ExpiredTime / 1000) / 60
         If ExpiredMinutes >= IDLEMINUTES Then
            ' ...if so, then reset the expired time to zero...
            ExpiredTime = 0
             '...and call the IdleTimeDetected subroutine.
            
            IdleTimeDetected ExpiredMinutes
          End If
         
         
         'Dim dtTime As Date
'dtTime = TimeValue(Time)
'If dtTime >= #8:20:00 AM# Then
    'Application.Quit
'End If

End Sub
 

Users who are viewing this thread

Back
Top Bottom