Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Question Unanswered: Date overdue Field change

    I have a database for lost tools that has a suspense date on the form. I need to have an e-mail sent to a specific e-mail recepient and the text color on the form to change to red when the suspense date field passes the current date. I also need the suspense date field on the form to change to yellow the day before it becomes overdue. How can this be accomplished without having to tie it to a SQL database engine?
    Thanks in advance for any help that you can give me.

    Cory M Greenwell

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Date overdue Field change

    Originally posted by eaglecmg
    I have a database for lost tools that has a suspense date on the form. I need to have an e-mail sent to a specific e-mail recepient and the text color on the form to change to red when the suspense date field passes the current date. I also need the suspense date field on the form to change to yellow the day before it becomes overdue. How can this be accomplished without having to tie it to a SQL database engine?
    Thanks in advance for any help that you can give me.

    Cory M Greenwell
    Cory,

    The first parts can be done by simple tests and setting the appropiate background color ... What do you mean by:
    How can this be accomplished without having to tie it to a SQL database engine?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •