Thread: Alerts on the basis of date

Originally Posted by Navneet

Hi!

I have a table in which all my vendors are listed,type of Annual Maintenance contracts(AMC),Department,Date of starting of contract & Date of expiry is present.I would like to make a Access file so that when the AMC is going to due in next 3 or 2 or 1 months system should give me POP up window or alert.

This is how column will be in ACCESS and its values.


VENDORS= ABC COMPANY
TYPE OF CONTRACT= ELECTRICAL
DEPARTMENT=MAINTENANCE
DATE OF CONTRACT= 01-01-2009
END OF CONTRACT=31-12-2009

So on 01-10-2009,01-11-2009 system should through a message box to user alerting him about expiry of contract.Atleast 1000 records will be there in access file.


Thanks


Navneet

Here is a sample dB that should get you started. I created a table with the fields you indicated above. You could have more obviously. I created a query that says, give me all contracts that will expire within the next 60 days. You can change this to what ever you want. Next I created an input form that is bound to the table with the same information. I then put code in the on load event for the form that says, open the query that shows the contracts expiring within the next 60 days. When you open the form, the query also opens. A query is better than a message box, as with over 1000 records, you may have many contracts expiring in the time fram indicated. You can fine tune this to your own needs, but this will get you started. Good Luck.

Hi Alan,
please refrain from quoting entire posts. It clutters the forum unnecessarily

You cannot apply the conditional formatting to a query. If you are looking for special formatting you will have to 1) create a report using the query as the record source or 2) export your query to excel and then apply conditional formatting.

As to your other question on check boxes, you could create a new field in your table and make it a yes/no field. In your criteria for your query for the new field, set yes or no to display the results.

Alan