Correct VBA Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Freehal04 - 27 Nov 2006 18:38 GMT

I've got my query set up to calculate a 10 day alert 10 days prior to a due
date. Finally, with a lot of help. I want to set up an automatic email to
recipients. I have code that works, but I am having trouble getting it to
run on the 10 day alert day. I was wondering if I need to write a macro in
my query or a little extra bit of code in VBA at the top of my automation
code to let access know that the specific date has arrived. Suggestions?
Thanks for the help.

Reply to this Message

John Vinson - 27 Nov 2006 22:13 GMT

>I've got my query set up to calculate a 10 day alert 10 days prior to a due
>date. Finally, with a lot of help. I want to set up an automatic email to
[quoted text clipped - 3 lines]
>code to let access know that the specific date has arrived. Suggestions?
>Thanks for the help.

You can use a criterion on the DueDate field of

=DateAdd("d", 10, Date())

Note that this may well miss some days unless you run the query every
day, Saturdays, Sundays and holidays included...

John W. Vinson[MVP]

Reply to this Message