how do I set up a warning macro

L

LisaB

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
 
S

Steve Schapel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top