Good afternoon,
I wrote a code on a hidden form to kick users out of the database if the current time (CurrentTime) is equal to or greater than the time I designate to kick the users out (TimeOut). Users could be in the middle of filling out a form and have an incomplete record. I need to make sure that the incomplete records don't save when they are being kicked out of the database. No matter what I try, I cannot get this to work. Right now, this is the code that I'm using:
Private Sub Form_Timer()
Me.Refresh
If Me.CurrentTime >= Me.TimeOut Then
Application.Quit (acQuitSaveNone)
End If
End Sub
Can anyone help me out here?
Thank you!