Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    18

    Unanswered: DoCmd.SendObj Keeps returning cancel error

    I have a function that uses docmd.sendobj to email reports.
    It works fine until the email is canceled. then it will not send again until the database is closed and restarted.
    This is Access2K and Outlook on Windows XP Pro
    I think this worked OK until I upgraded to XP but I'm not totaly sure.

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    You need to tell Access what to do if the event is cancelled with an error handler.

    HTH

  3. #3
    Join Date
    Feb 2002
    Posts
    18
    Thanks for the suggestion, but I was already handling the error.

    I solved the problem by creating another module for the function that was using sendobject, I do not know why it makes a difference as it worked ok before upgrading to XP but it did fix it.

Posting Permissions

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