Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62

    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???

    Thank you

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    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..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You have to handle your errors!!
    The generic VBA construct is like this
    Code:
    On Error GoTo ErrorHandlerLabel
    
        <your code>
    
    ExitHandlerLabel:
        Exit Sub
    
    ErrorHandlerLabel:
        MsgBox Err.Number & " " & Err.Description
        Resume ExitHandlerLabel
    Swap out the MsgBox for your email m'larky
    George
    Home | Blog

  4. #4
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62
    While using ErrorHandlerLabel is there are a way to send it e-mail to me ?

    Thank you very much.

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Plenty of methods: first port of call
    www.dbforums.com/search.php

    Emailing from Access is a very frequent topic so you should find lots to help you

    Let us know how you get on?
    George
    Home | Blog

  6. #6
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62
    Thank you - will try.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •