Autoreminder In Access using email or pop up

[thanosgr]

Hi Guys,



i have my car and i need an autoreminder that my car is ready for service.

So current km=10.000 next service 15.000km when next service is going to reach an alert will popup.



Access can use also outlook express? to send emails?

Any ideas how to implement this?

Thanks

[June7]

You could have code behind a form set to open on default when database opens. Could would check records and if criteria met, send email. Access can send email through Outlook, not sure about Express.

Having a running timer in Access does not seem easy. Think Access would have to be always open and timer hogs processing resources.

Why not use the Outlook calendar to notify you of the service date?

[thanosgr]

Actually what we do, is we insert the current klm of a vehicle and we have a field says when is the next service.(klm)..
So when the actual service is near (before lets say last 5000klm) an alert message will pop up...
Something like that

[June7]

You are already doing the reminder? Need to know how to send email? Common topic. Search forum or Google.