Search results

  1. C

    Help with Determing if Date is a Holiday

    Thank you so very much! That worked perfectly!!!
  2. C

    Help with Determing if Date is a Holiday

    Thank you so much. I'm almost there I think. I'm getting Compile Error: Else without If when I copy and paste that code in. I'm using Access 2007. Does that matter?
  3. C

    Help with Determing if Date is a Holiday

    I was trying this but not working...Can you tell me what is wrong with this? I put it in the before update event procedure. Thank you so much!! ElseIf Not IsNull(DLookup("HoliDate", "Holidays", "[HoliDate]=#" _ & DivHearingDate & "#")) Then MsgBox "This is a Holiday" End If...
  4. C

    Help with Determing if Date is a Holiday

    I have a form where the user enters a Hearing Date. I need to determine if that hearing date is a holiday. I have created a Holidays table with a list of our holidays in it. I wanted to enter an event procedure in the before update field of the hearing date to check the holidays table against...
Back
Top Bottom