Search results

I am using a nifty Workday function to calculate a date X number of workdays from another date. I can pass days of week and holidays not to calculate. Now that I have this function, I need to calculate variance, in the form of workdays, between two dates. I am hoping that this code can be...

I have a form to calculate cycle time based on 26 different possibilities, which are events in a sequence. I need to start with the first event that does not have a date entered and calculate estimated date of occurrence from there. The entries that do have events entered need to have a simple...

I am trying to calculate the value of a text box on a form with one of two formulas based on the value of another box. I would prefer to do this with the formula and not in VB (although if I must, I will). I attempted using =IIF(Isnull[KRecDate], [SalesDate]+2, [KRecDate] - [SalesDate] -2)...

I am using the built-in Calendar Control 12.0 with Access 2007. I have placed rectangles on the form over the calendar but the calendar seems to always be on top of them. I have brought them to the front, sent the calendar to the back, and they are still not there. I have verified that they...