Pop up alert

[Neil_Pattison]

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.

 

[Pauldohert]

Have a look at the Date and DateAdd functions to calculate the date which you would use as the criteria for a query to return the vehicles that need servicing.

You can call a form based on this query when you open the database, use Cancel = True in the open event of this form to cancel the opening if there are no records returned by the query.

Paul