i'm preparing a project called smarthome. this project are similar to alert/reminder system. i'm using VB 6.0 and MS Access for my database and this system is a standalone.
in this system, users have to define their assets (let's say cars) date to be serviced. system will notify the user via e-mail when the time has arrived (or maybe 2 weeks before the actual date).
1) how do i determine the frequency of reminders. lets say the service date is on 3/04/2004. so the reminders will be sent 2 weeks before, 1 week before, 3 days before, the day before and the day itself.
2) reminders will be sent to user through e-mail defined by the user.
3) user's computer (in which the system is operating) must stay online to send messages. messages will stay pending if there's no connection to the internet. ( am i right?)
ok that's it.
I offer you my points...ALL OF IT !!!!!
hope you can help.