Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2015
    Posts
    17

    Unanswered: Creating alerts in Access

    Hi

    I'd like to create an alert in access.

    For example, I'd like Access to alert me when certain things are due.

    For example, I'd like to set up an alert so that, for example, when inspections
    are due on properties within a certain timeframe, Access will let me know,
    perhaps even email me a list of the relevant properties.

    Is there a straightforward way of doing such a thing?

    For the Property Contacts table, the relevant fields are ID, Address, Comments and Date of Next Inspection.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    what about creating a form that open in a hidden state then use a time Event to check something them unhide it if true
    Last edited by myle; 09-09-15 at 23:56. Reason: spelling
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Jun 2015
    Posts
    17
    That's a really good idea. I understand how to create a hidden form, but how do I get it to unhide using a time event?
    What does the code for a time event look like?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I wouldn't bother with a hidden form or anything of that ilk. If I were you I'd run an overnight batch process which identified what was in the zone

    OR

    Id have a form and or report which identifies rows requiring attention

    as none of this is time critical (ie it doesn't matter if you are warned within n days, as opposed to right now this minute/this second) creating a hidden form seems uneccssary complicated.

    the overnight batch procerss could email the reprot to a specified list of recipients

    you would need some sort of threshold identifying when an action shoudl take place. IE an inspection should take place within n days of the next scheduled inspection. OR just simple report those within n weeks, grouped by week.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    Take a look at this link, I am sure that it will help you to plan and implement:

    http://www.msaccesstips.com/2007/09/reminder-popups/
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  6. #6
    Join Date
    Jun 2015
    Posts
    17
    thanks! Will have a go at some point.

Tags for this Thread

Posting Permissions

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