Auto print reports

  • Thread starter Thread starter kuslusr1
  • Start date Start date
K

kuslusr1

I have a form that auto prints a Report every 5 minutes. If and when the auto
print fails, I would like to know what time it failed or would like to have a
record of the last successful transmittion so I can manually send the report
items that generated after the failed print.
 
Create a log table that records when a report is printed and the result of
the printing. Use that to determine where to restart.
 
Dave, thanks for the information. I have never setup up a Log Table, could
you recommend reference material or please point me in the write direction.
 
Nothing magical about it. It is just a table. You probably want fields to
record:
Date/Time report started
Report Name
Error code

Then in the procedure where you print the report, add a new record with the
first two fields with the appropriate data and the Error Code field with 0.
Put an error handler in the procedure, and if it throws an error, update the
error code field with the error number that occured.
 
Back
Top