Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a database that uses the following On click event code

    Private Sub cmdPrintSecurityDepositRefund_Click()
    If [TrfDepositCheckBox] = -1 Then
    Me.DepositRefundAmt = 999
    Else: Me.DepositRefundAmt = Me.NetDepositAmt
    End If

    DoCmd.OpenReport "rptSecurityDepositRefund"

    DoCmd.SendObject acSendReport, "rptSecurityDepositRefund", acFormatSNP, "asacorp@sc.rr.com", , , "Security Deposit Refund Report", "The Security Deposit Refund Report is attached as a snapshop file", True
    DoCmd.Close acReport, "rptSecurityDepositRefund", acSaveNo
    DoCmd.Close acForm, "frmSecurityDepositRefund", acSaveNo
    DoCmd.Close acForm, "frmCheckOut", acSaveNo

    End Sub
    The code has been working for years at number of installations but one user recently upgraded to Windows 7 and is using Outlook 2003 SP3. The report opens fine and a hard copy can be printed but a runtime error 2293 is received when it tries to E-mail the snap report.

    Any suggestions.

    Tom Goodwin

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Tom,

    If I remember correctly, I do not think Windows Version 7 is compatible with the Snapshot Viewer which would cause the error.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks. I am not trying to read the SNP file in Windows 7 but to E-mail it to a user that is using Windows XP. The addressee has no problem reading SNP files send from other non Windows 7 users. It seems to me the problem must be some conflict between Access and Outlook rather than Windows 7 but I have never used Windows 7. I am guessing it is some type of security issue in Outlook but I am a non-Outlook user so really don't know where to begin.

    The DoCmd.SendObject has a True/False augment that deals with the ability of the sender to edit the email. It is currently set to True and we will try to see if changing it to false makes a difference. The problem computer is remote from my location and we probable won't be able to experiment until early next week.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    This Microsoft support document Outlook Error 2293 may be useful in chasing down what the issue is.
    Wendell

Posting Permissions

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