Results 1 to 4 of 4
  1. #1
    imintrouble is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    Missouri, where frownin's a sport
    Posts
    127

    query notification

    Hello,



    I need to create a query which takes a date stamp from the table it is connected to, then, in one column, post a date 60 days ahead of that. Then, once that 60 day date is reached, it needs to become highlighted (the background color needs to be changed) and probably send an e-mail to me saying that I had THIS many notifications.

    Thanks!

    Imintrouble

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    What is your question? Are you looking for the date

    function? If so, check this out:
    http://www.techonthenet.com/access/f...te/dateadd.php

    Sounds as if you need an Autoexec macro to check the date on open, but you don't mention if you already have one. Sounds as if you know how to change the background color, so ...

  3. #3
    imintrouble is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    Missouri, where frownin's a sport
    Posts
    127
    Thanks much for the link. It fixed the main problem spot on.

    Next however, I was in need of a way to get the background highlighted a color if the actual date is equal to the new column. so that if the column read 1/18/2012, and it was 1/18/2012 in real life, the background would be changed to red or something. Might this be done with an IIF statement? And if so, where would this go?

  4. #4
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    There are a number of ways to handle the change of

    background color. In the absence of information about your DB, here's what I would do:
    Set up an AUTOEXEC macro if you don't have one.
    In the AUTOEXEC, set a global constant (in the Visual Basic screen) to the normal background value.
    In the AUTOEXEC, query to see if the date is equal or greater than the target date. If so, set the global constant value to the alternate value.

    In design mode, set the form or control background to the global constant.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-15-2011, 08:47 AM
  2. Automated Email Notification
    By sai_rlaf in forum Access
    Replies: 5
    Last Post: 12-07-2011, 06:33 PM
  3. disable email notification by Outolook Express
    By maxbre in forum Programming
    Replies: 0
    Last Post: 12-02-2011, 05:19 AM
  4. check box notification
    By nichmeg in forum Programming
    Replies: 6
    Last Post: 10-29-2011, 11:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums