D
Dan Lavish
I have a request date field and a reply due date field on my form with
the code listed below on the request date after update event i was
wondering if there is a way to update this daily because after five
days its over due the problem is the only way to change it from a date
to overdue is too reenter the date it also shows up on a report so any
help is cool thanks in advance
Dan
Private Sub Request_Date_AfterUpdate()
If Date >= GetBusinessDay(Me.Request_Date, 6) Then
Me.Action_Overdue = "OVERDUE"
Else
Me.Action_Overdue = GetBusinessDay(Me.Request_Date, 5)
End If
End Sub
' the getBusinessday is a module that skips business days and holidays
thanks to some one else!
the code listed below on the request date after update event i was
wondering if there is a way to update this daily because after five
days its over due the problem is the only way to change it from a date
to overdue is too reenter the date it also shows up on a report so any
help is cool thanks in advance
Dan
Private Sub Request_Date_AfterUpdate()
If Date >= GetBusinessDay(Me.Request_Date, 6) Then
Me.Action_Overdue = "OVERDUE"
Else
Me.Action_Overdue = GetBusinessDay(Me.Request_Date, 5)
End If
End Sub
' the getBusinessday is a module that skips business days and holidays
thanks to some one else!