Reminder every 6 months

[theperson]

I want to create a query that says starting on a specific date, every 6 months a reminder will pop up when a certain report opens (or form, preferably a report). So if I said the starting date is 10/16/2013, once April 16th, 2014 hits and this user opens the report, a message pops up.

Another way would be to add that message to the report itself, so it's not technically a pop up but its built-in to the report.



Thanks!

[June7]

Can't do that in a query. That requires code behind a form or report.

[asmores]

There is a better way through VBA but the easilest method if you know the future run dates is to use a conditional macro that says:
Condition: "Date()=#04/16/14#"
Action: "Msgbox"

[theperson]

I don't have much experience with macros. Where do you put the condition? I selected MessageBox in the action category but don't see where I put the condition.

[June7]

I don't use macros but appears need to click the Conditions button on the ribbon.

[theperson]

I don't see that option on my ribbon.

[asmores]

In a new marco screen go to "View" on the top menu bar and select "conditions"

[theperson]

I inserted what my access macro screen looks like. I don't see View or conditions anywhere.

[June7]

Sorry, Access 2010 has changed the macro builder. Don't have 2010 here. Look at the right side of your image. See the If under Program Flow? Click it, what happens?

[theperson]

I figured it out. I just had to start out with an IF statement under that drop down box. Thanks guys!