Correct VBA Code

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

Guest

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.
 
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.
Click to expand...

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]
 
Back
Top