rohanjayanth
01-02-2015, 01:26 AM
Hi friends,
I have below code, i need to restrict the employee time sheet entry in daily log, which should not exceed 10 hours per day, particular emplyee / id should not enter more than 10 hours a day.
If VarType(DSum("[TIME_SPENT]", "[tbl_daily_log]", "[datec]=#" & Me.DATEc & "# and [OPE_id]=" & Me.OPE_ID & "")) > 10 Then
the above code is not working kindly help me.:hi:
I have below code, i need to restrict the employee time sheet entry in daily log, which should not exceed 10 hours per day, particular emplyee / id should not enter more than 10 hours a day.
If VarType(DSum("[TIME_SPENT]", "[tbl_daily_log]", "[datec]=#" & Me.DATEc & "# and [OPE_id]=" & Me.OPE_ID & "")) > 10 Then
the above code is not working kindly help me.:hi: