By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Access freezes after sendobject command when user cancels e-mail

P: 5
I've created an Access application in the 2003 file format that includes a button for the user to send a report via e-mail. The computers at work use Office 2007 products on Windows XP Pro with SP-3 but because of errors with our CRM we still use Outlook 2003.

Problem:
As long as the user actually sends the e-mail after the message opens in Outlook everything is fine. However, if the user closes the message without sending it the database freezes.

Here is the code:

Expand|Select|Wrap|Line Numbers
  1. Function SendEvalEmail()
  2. On Error GoTo SendEvalEmail_Err
  3.  
  4.     With CodeContextObject
  5.         DoCmd.SendObject acReport, "Email Observation", "PDFFormat(*.pdf)", "", "", "", "Email Observation of " & _
  6.         .Evaluation_FirstName & " " & _
  7.         .Evaluation_Middle & " " & _
  8.         .Evaluation_LastName & ", " & _
  9.         .Evaluation_Date, "", True, ""
  10.     End With
  11.  
  12.  
  13.     SendEvalEmail_Exit:
  14.     Exit Function
  15.  
  16.     SendEvalEmail_Err:
  17.     MsgBox "Unable to send evaluation. Please contact QA."
  18.     Resume SendEvalEmail_Exit
  19.  
  20. End Function
How can i prevent this from happening? Thank you in advance for your assistance. As this is my first post please let me know if I am following all of the posting rules correctly.
Feb 25 '10 #1

✓ answered by plaskettm

I know this post is old but I had exactly the same problem which was resovled by changing the form settings to Pop-up = No. Might be worth a go?

Share this Question
Share on Google+
2 Replies


P: 3
I know this post is old but I had exactly the same problem which was resovled by changing the form settings to Pop-up = No. Might be worth a go?
Jun 14 '10 #2

P: 5
@plaskettm
That did it!!! Wow, thank you. Now everyone will stop submitting problem tickets when it freezes on them.

Thank you so much!
Jun 16 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.