Link to home
Start Free TrialLog in
Avatar of ThomasEbeyer
ThomasEbeyer

asked on

MS Access date notification

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
Avatar of eetheredge
eetheredge
Flag of United States of America image

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

ASKER

I have never used Macro's before, does anyone mind walking me through this?
ASKER CERTIFIED SOLUTION
Avatar of zoom2000
zoom2000
Flag of Saudi Arabia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial