another conflict problem..

[mann2x]

i have two text boxes which are intended for time-in and time-out..what i need next is to check if the next time-in input is in between the previous time-in and time-out inputs and if it is then a conflict warning will appear..can this be done?please help me out..

[evander]

1. You need a field that you can later use for identifying what the "previous" row is.
2. You need knowledge in VBA, looping, and DAO recordset.

[mann2x]

1. You need a field that you can later use for identifying what the "previous" row is.
2. You need knowledge in VBA, looping, and DAO recordset.

can you give me a sample?

[slave138]

You could do it with DLookup assuming you have something like an employee ID, name, etc... in the data source:

If DLookup("[EmpID]", "[tblTimesheets]", "(#" & [Forms]![frmTimeEntry]![txtInTime] & "# Between [tblTimesheets].[InTime] AND [tblTimesheets].[OutTime]) AND [tblTimesheets].[EmpID]=" & Chr(34) & [Forms]![frmTimeEntry]![txtEmpID] & Chr(34)) Then
'Output error message
End If

The table and field names are obviously made up so remember to insert your own. It takes the Employee identifier from the form, and searches the table where the times are recorded for a matching ID. If any of the records match the ID it checks to see if the new time is between the related In and Out times. If it finds a match it flags it for your error handling otherwise it ignores the entry.

I would probably use the code in the [txtTimeIn] Lost Focus event or when pushing a button to add the record but it can be used a lot of different ways.

[mann2x]

gee thx dude!!thx a lot!!

[mann2x]

i forgot to tell you that a conflict will occur if these conditions are met:
allTimeIn < newTimeIn > allTimeOut And newDay = allDay
sheesh..helllllllllppppppp!

[slave138]

I'm not sure I follow...