PDA

View Full Version : Timesheet entry



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:

Bob Phillips
01-02-2015, 03:13 AM
You are going to have to do a lot better than that at explaining the problem. We need to know about the data, what you are trying to do (what does restrict mean in this contrext), and so on.

A workbook example would also help.