Forms popup dependant on user specified dates

[SteveC24]

Hi,

I have made a database to store information on people's fish tanks, and their fish etc.

A big part of keeping fish is that you need to keep on top of maintenace for the tank/filter etc.

I would like to add a function that you enter how often you would like to be notified about maintenance, then on database startup, it would check this, and show a popup message, or, even better, a form, to warn you to do whatever.

This, (i think) is remarkably complecated! ANY help is very gratefully received!

PS> I have very little understanding of VB! You know, just to make it more interesting!

Thanks,

 

[Newman]

You need a table with two fields: "Rate" & "Last",
Where "Rate" is how many days between each maintenance and where "Last" is the date where you did it last time.

Then you need a form where you add the "Rate" field (so that you could change it when you want to), a huge label saying "Maintenance time" and two command buttons: "Done" & "Later", where "Done" is clicked when you actualy do the maintenance and where "Later" is clicked when you don't do it and want to do it later.

In the "Open form" add something like this:
If DateAdd("d", [Rate], [Last]) < Date() then Me.Close

In the "Done_Click" add something like this:
[Last] = Date()
Me.Close

In the "Later_Click" add something like this:
Me.Close

(The code has not been tested but, from there, I'm sure you could run for the goal.)

 

[bjackson]

i dont know much about fish but wouldnt different tanks require
different maintaince tasks at different intervals,you may need a table for maintance tasks as well