I have a large accdb linked to SQL server which runs about 500 procedures (a form cmd runs an "EOD Procedure" (End Of Day) during the evening generating reports, letters, exports, imports.
The "EOD Procedure" takes from 2 to 6 hours the time depending of which day of the month is executed.
All the Public Procedures, Sub Procedures (Reports,etc) and Public Functions contain error handlers.
such as this sample:
Public Sub ClientLetter()
On Error GoTo ClientLetter_Error
...........................................................................
On Error GoTo 0
Exit Sub
ClientLetter_Error:
MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure ClientLetter of Module ModPublic"
End Sub
When an error occurs for any reason the EOD stops generating an Error msg.
The mission is to send an email to the Manager if the EOD stops due to any error (Null value, file not found, etc.).
This accdb has the capability to send emails for example if a client has an email then then via automation with Outlook the email is sent to the client attached a PDF file (Converted from the reports created by the EOD).
Please advise me if you have some suggestion how to approach this interested issue.
By the way in SQL I have a procedure which sends an email when a backup fails.
Norbert
Posted by: drnorbert@msn.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar