pop up alert

[NeilPattison]

I am developing a database for our fleet of company vehicles. What I'd like to know is is it possible to set up some kind of alert where a dialog box appears (like the sort of thing in Outlook with reminders).

What I'd like is, for example, if a vehicle requires a service a pop up would appear, a couple of weeks before, when the database is opened to alert the user that it will be required soon.

If anyone knows how to do this it would be greatly appreciated.

 

[mp9]

When your db loads, use a VBA or an AutoExec macro to run a query or do a DCount of vehicles where expiry date - 30 is less then today's date. If there are some, then pop up the relevant form or a message box to inform the user.

 

[tpsmith]

Hi

You could also have a form running as hidden in the back ground of your application which has a timer event checking every minute for values that meet your criteria and then popping up a message box.

Cheers
Tony