The Security Officer has asked me to create a little something to manage the records of the various tasks that must be done throughout the day. Therefore, I chose MS Access to do the task.
Here is the schedule of the person responsible for the shift that starts at 9:30 in the morning:
9:30 a.m. to 6:00 p.m., after what the building is locked until the next morning, and
6:00 a.m. to 9:30 a.m., where someone else takes over for the new day.
So, everyday a new shift worker comes in and log himself in on the workstation.
Now here is my issue:
I want, the person who goes off shift at 9:30 have an extra 30 minutes to make any changes to the information he recorded in the database if required, after which he will have to contact the Security Officer. So, after 10:00 a.m., it is no longer possible for anyone to make changes to the previous day records.
In the table (T_Rapport of Svc), I have DateMod and TimeMod fields which are populated with NOW () and a field 'EnteredBy' which prevents anyone from changing records when activating the working form, with the exception of the person who created the record. The field 'EnteredBy’ is populated with the username of the person who is logged in.
According to my research, the fact of using DateTimeStamp would work, but where exactly I can apply this option still remains a mystery for me.
So, my question is as follows: How to prevent changes to the records past 10:00 AM?
Thank you in advance for your help in hoping my details are clear enough.
Here is the schedule of the person responsible for the shift that starts at 9:30 in the morning:
9:30 a.m. to 6:00 p.m., after what the building is locked until the next morning, and
6:00 a.m. to 9:30 a.m., where someone else takes over for the new day.
So, everyday a new shift worker comes in and log himself in on the workstation.
Now here is my issue:
I want, the person who goes off shift at 9:30 have an extra 30 minutes to make any changes to the information he recorded in the database if required, after which he will have to contact the Security Officer. So, after 10:00 a.m., it is no longer possible for anyone to make changes to the previous day records.
In the table (T_Rapport of Svc), I have DateMod and TimeMod fields which are populated with NOW () and a field 'EnteredBy' which prevents anyone from changing records when activating the working form, with the exception of the person who created the record. The field 'EnteredBy’ is populated with the username of the person who is logged in.
According to my research, the fact of using DateTimeStamp would work, but where exactly I can apply this option still remains a mystery for me.
So, my question is as follows: How to prevent changes to the records past 10:00 AM?
Thank you in advance for your help in hoping my details are clear enough.