Hi,
I have put an expression in a query (NACDue: [HireDate] + 60) so that I know the due date for an employee to turn in their NAC (National Agency Check). This works great.
I have created a report based off the query. I want to know when someone is over due in getting their NAC submitted to our department. I have put the following code in the on format event of the details section of the report.
If CDate(NACDue) < Date() Then
NACDue.ForeColor = vbRed
Else
NACDue.ForeColor = vbBlack
End If
I get an Compile Error: Method or data member not found. The .ForeColor is selected when I click on ok. I have asked Paul Bricker about this (and he had given me the above code) but since I am sitting at my laptop and don't have an email address programed on it yet, I thought I would post my question here.
Thanks in advance for your help.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net
I have put an expression in a query (NACDue: [HireDate] + 60) so that I know the due date for an employee to turn in their NAC (National Agency Check). This works great.
I have created a report based off the query. I want to know when someone is over due in getting their NAC submitted to our department. I have put the following code in the on format event of the details section of the report.
If CDate(NACDue) < Date() Then
NACDue.ForeColor = vbRed
Else
NACDue.ForeColor = vbBlack
End If
I get an Compile Error: Method or data member not found. The .ForeColor is selected when I click on ok. I have asked Paul Bricker about this (and he had given me the above code) but since I am sitting at my laptop and don't have an email address programed on it yet, I thought I would post my question here.
Thanks in advance for your help.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net