limit number of hours entries per day

[shod90]

Dear Gents,
I have a time sheet application and trying to limit users to enter only 8 hours per day , if the value was more than 8 it shows pop up window " You can't enter more than 8 hours per day "



here is my code to solve this problem except that i can't specify the date

Private Sub Hours_AfterUpdate()
If Me.Hours.Value > 8 Then
Me.Add_Record.Enabled = False
MsgBox "You are trying to add more than 8 hours / Day , Please use overtime box if you are trying to add overtime hours", vbInformation
Else
Me.Add_Record.Enabled = True
End If
End Sub

[Missinglinq]

...i can't specify the date...

We really need more info to help you. Why do you need to specify the date? There should be a separate Record for each employee each day.

Linq ;0)>

[pbaldy]

I would assume this record was date-specific, so in what way do you need to add a date test?

[shod90]

We really need more info to help you. Why do you need to specify the date? There should be a separate Record for each employee each day.

Linq ;0)>

Okay you are right , But what if the user entered 2 records in day each with 4 hours so the total of the day will be 8 hours.
that's why i need to specify date , on ( each ) date should be only 8 hours , No matter if he entered the same date 2 or 3 or maybe more but the most important is this date for this user can't be more than 8 hours.

[shod90]

I would assume this record was date-specific, so in what way do you need to add a date test?

As i said to missinglinq , Suppose the user entered the date more than one time ? , I need to limit the date of the day as example: the user entered on the begining of the day 2 hours , then he again opened the database and entered 2 more hours , now the total is 4 hours in this day so he still have 4 hours remaining , After entering the 4 hours the add record button should be disabled.

[pbaldy]

You can use a DSum() with the appropriate criteria:

DLookup Usage Samples