how do I set up a warning macro

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

Guest

I need to know how to set up a pop up warning message when certain records
reach 2 weeks before a particular date. I assume this is a macro??

i'm setting up a student data base and i need to know 2 weeks before
students are being released from the course
Thanks in advance.
Lisa
 
Lisa,

In orer for anyone to give any specific help on this, we would need to
know how you can identify the students' date of release from the course.
But the general principle would be to make a query that returns a list
of students whose release date is within 2 weeks, and then make a macro
with a MsgBox action, and in the Condition of the macro, put the
equivalent of...
DCount("*","NameOfYourQuery")>0
 
Back
Top