Search results

  1. J

    Multiple criteria to consider to return a value in a query

    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...
  2. J

    MsgBox to display using Timer event

    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...
  3. J

    Format text boxes on continuous form based on system date

    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.
  4. J

    Message popup 30 minutes after checkbox event

    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.
Back
Top Bottom