I need a message box that will notify me to run an update query

T

traceym13

I need to be warned when to run a price update query 90 days prior to the
anniversary date. I have a created a macro that will run the update query
but I need a message box to notify me when to run this query.
 
M

mscertified

assuming your application is used daily:

if datediff("d",Date,AnniversaryDate) <= 90 Then
msgbox "Run price update query",vbokonly,"Reminder"
end if

-Dorian
 
T

traceym13

Yes my application is used daily. I am a newby so bear with me. I can get
the query to pull up the appropriate records, and the macro to run the query,
but I don't understand how to get the macro to run automatically when I open
the database?

What does vbokonly mean and where does the "Reminder" and end if go?
 
Top