Need script to alert user when time elapsed from last file save

[Guest]

Need script to alert user when time elapsed from last file save = 7 hours.
This is for an access database file that has been placed on several
workstations and linked to a master collection database on the server. Users
must record an entry at least every 8 hours, but in order to secure the
records we have not allowed them access to previously entered records so they
have no way of knowing what time the last entry was recorded.

I am still in the process of learning Access, and I cannot find a way to do
this within the program. I am assuming I need to do this through a script,
which I have absolutely no experience in at all.

Thanks for your help.

 

[Guest]

You can put a text box in the form footer section with the function =date()
Each time a record is saved update this text box. If a record is added at
12:50 pm then the time will remain 12:50 pm until a new record is saved. No
script needed but you need users who know how to subtract times.

If you want a msgbox to pop in the middle of the screen letting your users
know that it has been 7 hours since their last entry, then you need VBA
coding.

If you want to use a VB Script then contact your IT staff because you need
to know group policies set in the network.