how do i set up a vehicle maintenance database?

[Mr. Maverick]

I'm trying to set up some sort of monitoring system for the oil change,
(mileage or date) for about #80 vehicles, as well as the registration sticker
dates , and the mileages etc. I need something that will automatically appear
on my screen in the morning that yells at me which vehicles need attention.
thanks.

 

[Evi]

You can have a form which you set to startup when you open the database
(this is really easy)

In the On Open Event of the form (getting a bit more technical now but not
too difficult), it checks a query which contains the DueDate for a
procedure. (this may be able to be calculated by adding a set number of days
to the date when the procedure was last carried out or it may need to be a
date which you enter into a table - depending on how these things are
calculated) The query is based on the the VehicleMaintenance and is filtered
under the DueDate with the Criteria

=Date()

(Easy)

So if there is anything in that query, it will open and show you that list.
Don't know about the yelling though! It can be done but its a fairly
sophisticated bit of coding.
Evi