Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Button Problem (2k)

    I used the standard mail button and haven't changed the coding in it at all. It works fine for me on my computer, but when my users try to use the feature, they have problems: 1) Freezes the db and access if outlook isn't open and they get prompted to open it, OR if they cancel it before opening outlook. 2) Freezes the db if outlook IS open and the mail isn't sent, and i don't know if it will freeze it if the mail is sent. Also if you try exiting through the access application [X] - a message pops up saying Access can't close because of a VBA function. And this is the generic VBA put into the button:

    Private Sub Command270_Click()
    On Error GoTo Err_Command270_Click

    Dim stDocName As String

    stDocName = "Solid_Checklist_Report"
    DoCmd.SendObject acReport, stDocName

    Exit_Command270_Click:
    Exit Sub

    Err_Command270_Click:
    MsgBox Err.Description
    Resume Exit_Command270_Click

    End Sub

    only thing changed was the report name. also the report is being mailed in snapshot format.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail Button Problem (2k)

    Could be there is a dialog that waits for input, but didn't get the focus. For example a dialog that asks the user to select an Outlook profile, or for permission to allow another application to send mail. Let the user hold Alt, then press Tab a few times to see if there is a dialog lurking in the background.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Button Problem (2k)

    I saw the same prompts that he got on mine, and there was nothing in Task manager. I guess I could have missed that, I'll check on it.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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