Search results

OK, thanks for the advice. I will see what I can come up with.

I am trying to write an IIf statement that considers multiple criteria to return a value of y or n based on day of week and time of day to determine if an event would be considered "on-call". There are multiple facilities (three) and the rules are slightly different for each each facility...

OK, that was the problem. When I changed the code to make Me.Time1 = Time() it worked. I also amended the code so that I did not need 2 time text boxes. So my code looks like: On the click event of the button: Me.Time1 = DateAdd("n", 15, Time()) which establishes the time for the msg box to...

I have a form (MS Access 2003) that has a button that when pressed, assigns the current time to field [Time1] using Me.Time1 = Now() I have another field [Time2] that adds 15 minutes to [Time1] using the following in the Control Source field =DateAdd("n",15,[Time1]) I was wanting to use these to...

OK, I figured it out. Basically, I have to put this expression on each control for conditional format: [StartTime]<Date() This works...thanks for your help!

So I have to use conditional formatting for each text box? That is, I need to set each text box based on an expression related to the system time? I have been successful updating the background color of the one control using the conditional formatting function but not sure how to get the other...

OK, thanks will give it a try

Hi, I am having trouble finding the right VBA to do this, but I have a continuous form (2003) with 6 text boxes (StartTime, StopTime, Comments etc...). I would like all the text boxes to have a gray background if the StartTime for that row is less than Today(). Any help is appreciated.

I would like to have a message box popup 30 minutes after a user checks a checkbox (check5). I am thinking I would have to have VBA code to run on the After Update property of the checkbox but not sure what the correct code would be. Any help would be appreciated. Thanks.