We help IT Professionals succeed at work.
Get Started

Set a reminder based on a varaible of days after an event

yddadsjd95 asked
Last Modified: 2013-11-28
Great Day, I am working on an application for a small vehicle repair shop. It keeps track of customers' estimates and repair orders. It also keeps track of a repair item that the technician may discover while working on a repair order: For instance, the customer may bring the car in for an oil change, but the technician sees that a wheel bearing needs to be replaced. What I would like to do is identify the wheel bearing as something that needs to be done down the road,  but it could be anything from something minor to something major. I have a field that permits the user to identify the replacement of the wheel bearing as something that needs to be done. I also have a field where I place the number of days from the repair when I would like to send an email reminder of this particular service item. The reminder can be set for 10 days or 20 days or 30 days, etc.

What would I need to do to have access remind me that it is now time to send the email reminder to the customer?

Thanks in advance for the assistance.

Watch Question
This problem has been solved!
Unlock 2 Answers and 7 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE