var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Process fail notification
I have a program inside Access that runs some daily tasks (such as data load from txt, update tables etc...).
This process is an automated process, and runs every day at 5 am.
If it fails, (let’s say txt data wasn’t loaded) …….
I will not know up until I ran other process in the morning.
Is there are a way to notify user, that this process fail to run???
Get it to send an e-mail?
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
You have to handle your errors!!
The generic VBA construct is like this
Swap out the MsgBox for your email m'larky
On Error GoTo ErrorHandlerLabel
MsgBox Err.Number & " " & Err.Description
While using ErrorHandlerLabel is there are a way to send it e-mail to me ?
Thank you very much.
Plenty of methods: first port of call
Emailing from Access is a very frequent topic so you should find lots to help you
Let us know how you get on?