popup reminders

[Guest]

I currently am managing and equipment database using MS Access and would like
to know if there is a way to be reminded when maintenence is due on said
equipment even if it uses Outlook or a report from within Access.

 

[Guest]

A couple of things --
Periodic maintenance can be trigger based on when the last maintenance was
scheduled or when the last maintenance was completed. Maintenance can be
based on the calendar - every three months or on operations - 3,000 miles,
1500 hours.
Maintenance data collection can be to just record the last and next or to
keep a record of each maintenance action. To keep a record for each action
you will need a separate table that is linked to the equipment table in a
one-to-many, equipment to maintenance.

Your database can have a macro (Autoexec) that runs every time it is opened
and query to see what maintenance actions are due in the next X days and list
them in a popup.

Of course if you were going to take a vehicle on the road for a week you
would want to know what maintenance will be due within the next week and
half. You will need a separate query for this or include the criteria as an
option for the popup query.