Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Unanswered: Setting up alarm on behalf of due Date

    hi Everyone i am working on a project and customer wants me to set a alarm so they enable to send reports before the due date. i Have a test date and on behalf of test date date is calculated either six month or 12 months. Now i want to set a alarm so one month before i can enable to know that retesting date is due...........
    Reply please
    As soon as possible

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Comparig two dates is not an issue (DateAdd, DateDiff etc...).

    The problem is that it must be done on a regular basis which means that the application must run on a regular basis.

    You could write a little application in Access (or VB or C# or any other language) that automatically just checks for the due date and performs something in case of a match (print a report, send an email, set a flag in a table, run a query ...) and have it run through the scheduler of Windows (see: How To Schedule Tasks in Windows XP. This implies that the computer is on, of course!

    If the "main" application is run regularly, this task can also be performed when the application is starting.

    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    One of my customers has a database that runs 17 different "alarms"... and it doesn't just pop up a message (which almost always gets ignored), instead it spams people's inboxes until it's dealt with ^^

    I love it, it appeals to my sense of humour, but the users get annoyed when the system trashes their inbox until they do their work!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by StarTrekker
    One of my customers has a database that runs 17 different "alarms"... and it doesn't just pop up a message (which almost always gets ignored), instead it spams people's inboxes until it's dealt with ^^

    I love it, it appeals to my sense of humour, but the users get annoyed when the system trashes their inbox until they do their work!!

    ..like the style there ST, that'll teach them to do their work on time (until that is someone works out how to chuck such emails into the spam bucket)
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If those users knew how to, they could set up rules for outlook I suppose, but that kind of dodging work would get them fired!

    The application has a nice feature though... when it is first started up, it says on the status bar: "Spamming... please wait..." then "Spamming complete." ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    May 2006
    Posts
    178
    Guys,

    This sounds interesting, id like to incorporate this automated emailing of reports.

    any one got any code for this?


    Aboo

Posting Permissions

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