Hi Richard,
I am still having problems with the schedulingF returning errors.  I believe this is to do with my location settings and the date format.

I have downloaded your student database, and it is returning the same error.

When I type in the begindatetime field, I get the following error:

Run-time error '3075':
Syntax error (missing operator) in query expression 'WorkerID= AND ScheduleID <> 25 AND BeginDateTime < #17/9/2014 7:00:00 a.m.# AND EndDateTime > #17/09/2014 7:00:00 a.m.#'.

If I then click debug, this is where the error is...

Private Sub BeginDateTime_AfterUpdate()

    If Hour(BeginDateTime) = 0 And Minute(BeginDateTime) = 0 Then
        BeginDateTime = BeginDateTime + (9 / 24)
    End If
    
    ' check for conflicting appointments
    Dim ID As Long
    Dim MyReply
    'On Error Resume Next
    ID = 0
ERROR IS HERE   ID = Nz(DLookup("ScheduleID", "ScheduleT", "WorkerID=" & WorkerCombo & " AND " & _
        "ScheduleID <> " & ScheduleID & " AND " & _
        "BeginDateTime < #" & BeginDateTime & "# AND " & _
        "EndDateTime > #" & BeginDateTime & "#"), 0) ERROR ENDS HERE
    If ID <> 0 Then
        'we have a conflict!
        MyReply = MsgBox("Scheduling CONFLICT found. Keep appointment anyhow?", vbYesNoCancel)
        If MyReply = vbNo Then
            BeginDateTime = Null
            EndDateTime = Null
            Exit Sub
        End If
    End If

    If IsNull(EndDateTime) Then
        EndDateTime = BeginDateTime + (1 / 24)
    End If

I am convinced my problems with dates in access, all stem from the fact that my computers location and regional settings are for New Zealand.

I've tried everything, googling, looking at Allen Brownes international date post etc, but I really don't know how to fix this.  And as I said, even downloading your student database, then reports errors.

Please help me.

Thanks
Lynda