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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
assuming your application is used daily:

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

-Dorian
 
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?
 
Back
Top