Reminder message box every 3/6/9/12 months

[Koullis]

I am working on a project for my brother. The program is about reminding him for the maintenance of a machine that a customer has. Each machine has to be maintained every 3 or 6 or 9 or 12 months. This is going to be selected from the user during the insertion of the machine in the database. The more confusing factor in the case, is that he requires to have all the machines in a single region maintained in a sequence. Can you suggest me anything?


Thanks.

[pkstormy]

You'll want a field for 'region', a field for 'sequence', and a field for the 'maintenance date' (probably in a 2nd relational table). You'll want a table to hold customers and a relational table to join customers to machines.

(and a few other miscellaneous tables/fields.)

[Koullis]

Firstly, thanks for replying.
I already have a region and a sequence field.The first is in the table customers and the second in the machine. However, I would like to avoid the maintenance day field because he will not know which day is available.
I am thinking to add an event when the mouse moves on the welcome form to show a message box for an oncoming maintenance.Can you suggest anything?I know it will be a vb code as a macro is too simple for this but I can't think of anything.
Please suggest me a way.