Warrantee alert

[Kabous07]

Good day

I'm working for a company that sells refrigeration equipment. Part of my job is to keep track of projects we are doing. Currently we are using excel and it is getting a pain because there is so many data to put in. I want to start doing this in access via forms that the personnel can fill in every time they have a new site. But I have one problem:

1. I need to be able to see if the if a site is outside warrantee. For instance a client will place a order on the 17/06/2015 and then 18 months from this date of order the warrantee will expire. Meaning if I go back to this job, on the table data, there must be something in a cell informing me this is out of warrantee. Is this possible for access to do such a timer based(18 months) alert?

Thank you allot

 

[spikepl]

You do not want alerts, because you'll drown in them and they will eventually all be dismissed.

You want a summary displayed in a corner somewhere: e.g. number of sites expired today. You click on that and see an overview: a list of all sites expired and the ones with perhaps some given number of days left. The expired ones perhaps coloured red, the ones with 1 week to go , yellow. That's easy with conditional fomatting, applied to dates that stem from 18 months prior.

 

[Kabous07]

That will actually be perfect! How do I assign the sites(rows) with the function to inform access that it is out of warrantee from order. I like your idea allot more

 

[Kabous07]

With queries do I retrieve data and then forms do I input data?

 

[spikepl]

Largely, yes. Do a web tutorial on each - the best hour you can spend.

 

[Kabous07]

Thank you spikepl. Can you maybe explain how I do instruct access to use conditional formatting when the time of a specific site is finished?

 

[Kabous07]

I tried using conditional formatting based on the date, so I gave it a separate date up to warrantee date more or less. Once that date has been reached it will go red. Ill assume it stays red if I say; [=>19-06-2015]