Search results

  1. A

    Web form won't load

    I have an Access 2010 web database--very simple, one table, one form, one report--just a suggestion box for employees. It was created as a web db and uploaded to SharePoint 2010 (SharePoint Enterprise, with the latest versions of IIS and SQL). It runs beautifully from inside our company network...
  2. A

    Change text box backcolor conditionally

    Brilliant! I just made a couple of tweaks: I changed the < to > in the third item and used Value Is Between Date() and Date()+30 for the second item. And it works!!! Now I just wish I could have a fourth criterion to change color again when the evaluation is due within the next week... Ah...
  3. A

    Change text box backcolor conditionally

    I see that I could have another criterion in conditional formatting that uses "Expression is" rather than "Field value is." I've put in = IIf([ReviewDone].[Value]=-1,"white","red") but still nothing's happening. Expressions aren't my strong point. Any idea why this doesn't work?
  4. A

    Change text box backcolor conditionally

    Thanks for your reply. I agree, using conditional formatting for everything would be a lot easier, and it works fine for changing the backcolor to either yellow (for upcoming) or red (for overdue) according to the value in the [ReviewDate] field. However, in conditional formatting, how do I...
  5. A

    Change text box backcolor conditionally

    Hello All This should be easy, but as I'm not very experienced with VBA, it's not. I have an Access 2010 database to hold employee data and I have a report to flag when a performance review is coming up, overdue or done. The textbox (Date/Time type) that holds the review date is called...
Back
Top Bottom