auto close

Hi All, I'm wondering if someone can help, I have a shared workbook that I've added the below code to so that it automatically saves and closes if someone has it open for 30 minutes and hasn't used it (it was constantly annoying people leaving it open all the time!!) :banghead: It works...

Hey Everybody, Not sure if this is already a thread as I've tried searching for answers but come up with only half solutions to what I needed, or incomplete code. I've tried a smattering of code I could find in the forums, and even tried combining bits and pieces, but to no avail. This is...

Hello Friends Is there any way I can get Access DB to auto close in case there is no activity for a certain peiod of time? I am maintaining a database in MS Access and have multiple ACCDE files distributed to users for running queries that they need. I update backend database once (sometimes...

I found this code at vbaexpress & it works as expected. Option Explicit Const WelcomePage = "Macros" Private Sub Workbook_BeforeClose(Cancel As Boolean) 'Turn off events to prevent unwanted loops Application.EnableEvents = False 'Evaluate if workbook is saved and...