Is it possible to set reminders on access databases?

[YAPKT]

I am setting up a database at work to record when 6 monthly questionnaires
have been sent out. Is it possible to set up a reminder system that flags up
when they need to be sent - unfortunately the dates are different for each
client.

Thanks!

 

[Rick B]

Sure. Lots of ways to do that. Just build a query that pulls up all the
records where the date is between now and 14 days from now. (Or however
long you think you will need).

Do you mark it when the reminder is sent? If so, make sure to exclude
records if the item has been sent.

You can tie this query to a form that opens when you start the database, you
could tie it to a report that is run by the user, etc.

 

[YAPKT]

Can you help with the expression? Basically the 2 columns I'm having
problems are: the first one is a date and the second is a checkbox confirming
if the letter has been sent out on that date. In the criteria box on the
query, what expression would I write so that the date column only comes up if
the checkbox hasn't been ticked (i.e. if the letter has been sent out, that
date won't come up)? I'm really baffled by this one!

Thanks!