Search results

  1. G

    How to change controlsource of multiple textboxes with public function

    I have multiple reports that use similar IIF statements as the controlsource for four textboxes. Naturally, I don't want to have to update twelve controlsources if any of the calculations change, so I thought I'd make this a public function. However, I don't know how to pass along multiple...
  2. G

    IIf statements with AND (multiple criteria)

    I have a list of projects and I need to display their status (Red or Green) in a text box. My fields are [PercentComplete],[StartDate],[EndDate],[ReportDate] There are two ways a project could have a red status. 1. [PercentComplete] < 100 AND [ReportDate] < [EndDate] OR 2...
  3. G

    Using datediff in a non-normalized database

    Surely someone has done this, but I am having a lot of trouble figuring out the correct keywords to search for. I have a SharePoint list that tracks the date/time of each stop of an order from its origin to its destination. The number of stops varies depending on the type of order (you can use...
  4. G

    Stop generating message boxes on form close

    I have some code (see below) that checks if the start date text box is blank or greater than the end date, and if so, generates a message box and sets the focus back to the start date textbox. There are command buttons on the form that open queries based on the date fields. This all works fine...
  5. G

    Need to display dates no one worked on a project

    I have a table that records when someone has started and stopped working on a project. The fields are Project, StartTime, EndTime. The start/end time fields are Long Dates. The sample data is something like Walk Dog, 2/22/2013 11:00, 2/22/2013 11:30 Walk Dog, 2/22/2013 19:00, 2/22/2013 19:30...
Back
Top Bottom