By Richard Rost 24 days ago
AutoSave Form Data at Timed Intervals in Access
Word and Excel have an AutoSave. Why not Access? In this Microsoft Access tutorial, I'm going to teach you how to have your form automatically save data at a timed interval. So, if someone walks away from the computer in the middle of editing a record, it will automatically save after, say, 3 minutes.
Declan from San Francisco, California (a Platinum Member) asks: I run a call center and have a problem where my employees will get up and walk away from the computer in the middle of entering a record without saving it. They'll go on a smoke break, or even go out to lunch, or sometimes even go home before saving their work. Of course, if that caller calls back and someone else goes to open the record, they don't see the most up-to-date changes. Is there any way to have the database automatically save changes every minute or two in case this happens?
Members will learn how to stop the Autosave from kicking in while the user is actively editing the record. This way he won't be interrupted while typing and have the form save and reset.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Autosave records in access, refresh interval, auto save, automatically save, keypress, key press, on mouse over, button press events, Key preview, keypreview, how to automatically save records after a timed interval in microsoft access
Subscribe to AutoSave
Get notifications when this page is updated