H
Haze1023
I have an Access database, that maintains Work Orders, and once approved,
emails them using DoCmd.SendObject.
The code I have been using has been working fine for 2 years, and now 3
times it one day has miss routed work orders.
The module, runs a query, that tells it which work orders need sent out,
opens a form, filtered for only that work order ID, and then has a
DoCmd.SendObject to send out a report for that specific Work Order id. One
report per e-mail. All of a sudden along with the correct report it has
started attaching an additional, unrelated report. (I can even figure out
how it is accessing it since the data is in a different table (Archived))
could there be residuals from the varables I use? Though I haven't run
anything for Archiving in over a week, and this automated process that runs
via schedule tasks every 10 minutes.
Thanks in Advance
Jessica
emails them using DoCmd.SendObject.
The code I have been using has been working fine for 2 years, and now 3
times it one day has miss routed work orders.
The module, runs a query, that tells it which work orders need sent out,
opens a form, filtered for only that work order ID, and then has a
DoCmd.SendObject to send out a report for that specific Work Order id. One
report per e-mail. All of a sudden along with the correct report it has
started attaching an additional, unrelated report. (I can even figure out
how it is accessing it since the data is in a different table (Archived))
could there be residuals from the varables I use? Though I haven't run
anything for Archiving in over a week, and this automated process that runs
via schedule tasks every 10 minutes.
Thanks in Advance
Jessica