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
Bookmarks