Access database Need to prevent from approving overlapping OT.Second Try with modified request Not a programmer [on hold]
- by user2512764
Employees Signups on company Website for advance overtime line. Access table already has overtime signups which does not require user to add the time but it requires only to add location as approved.
Since this table has field Employee name, Date, start time and End time and location, All the fields has the data except for location.
In the data base I have created a form based on this table. Since the table already have most of the information User only has to add location in the form field in order to approve overtime.
Once user approves an overtime line for example: User approves overtime for employee name 'John' which starts on 7/1/2013 at 0400-0800, location is successfully added.
When user tries to add location for John again which might has the start time for 7/1/2013 at 0600=0900. Again we are not entering Start time, End time and date it is already in the table. we are only entering location as approval.
Soon user enters the location for John in the form field, since there is a conflict with previously overtime line which has already been approved. program needs to check employee name, date and time in previously approved (Added location) overtime line and The location in current record needs to be deleted and go to next record. I hope I have explained it in understandable format. Thank You,
