Creating an automatic alert when query is run

[Cwire]

Is there a way to have Access send an alert message when a particular date is getting close? I have a database that tracks automatic step increases to pay and when the dates occur. I would like to create a pop up that could alert me when a date is getting close so that I can inform the budget person that a certain employee will be getting a bump in their pay starting on a particular date? Is that possible in 2010?

 

[Trevor G]

You could set up a query and convert that to a form and use the form when the database starts. Autoexec Macro or File Options Current Database and select the form.

You would need to give more details if you need help in doing this.

 

[Cwire]

Thanks Trevor, I'm not sure umm what you mean though. I know how to do Query's and I know how to do forms but I'm not sure what you mean by creating the Query then making it a form?

 

[burrina]

Here is an Example using the OnLoadEvent for a Main form.
AnyDate = Date
Monday = The current Monday.
Replace with your criteria and form name.

If Me.AnyDate = Me.Monday Then                     'Payroll Reminder.
DoCmd.OpenForm "frmPayrollChanges"

If not, Please explain further.