MS Access date notification

Posted on 2008-11-10
Last Modified: 2012-05-05
Currently I am using Access for a customer database, In my database table, there is a column for the date the Customer Transaction took place. My goal is to make access inform me that it has been x years since the transaction and the customer must be called. For example if a job was done Jan 1st 2005, i may want the program to inform me on jan 1st 2009 that it is time to call the customer for another job. Is this possible?
Thank You
Question by:ThomasEbeyer
    LVL 1

    Expert Comment

    You can attempt to use a Macro where conditions are set to email when the trigger occurs.  

    Author Comment

    I have never used Macro's before, does anyone mind walking me through this?
    LVL 2

    Accepted Solution

    1- Make a function for Inquiry about that.

    2- Put  acode in application main form_open event
    to call this function.  

    3- If it true , display a msgbox about this.

    sorry it's short but I have no details
    If you provide more details , I can give more help

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now