Angelina725
Last Activity: Sep 24 '10, 02:47 PM
Joined: Sep 21 '10
Location:
-
Thank you both for your help but Google finally prevailed! The problem was the name of my function and the name of my VBA module were the same. Once I renamed my VBA module the function worked. -
Yes. I already have a holiday table created and I have the code written for a custom function but every time I try to use my function in a query it returns an undefined function error. Code is below:
Public Function NetWorkDays(dte Start As Date, dteEnd As Date) As Integer
Dim intGrossDays As Integer
Dim dteCurrDate As Date
Dim i As Integer
intGrossDays = DateDiff("d", dteStart,...Leave a comment:
-
Conditional formatting in a report based on 2 criteria including dates
I created a database that tracks the process of building a complex document with several approval steps. On one of the reports, I would like to use conditional formatting based on the following:
If [Approval Received] is null and [Approval Sent to Supervisor] > 5 business days prior to current date, color [Approval Received] text box red
I have attempted using the NetworkDays formula but I can't seem to translate...
No activity results to display
Leave a comment: