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

    Unanswered: Error 2465 when trying to send report using SendObject

    Hi Everyone,

    I have been having a problem with emailing reports using SendObject. Basically, my form has an option group with the options "Preview, Print, & Email". When a report is selected, and executed this Sub is called:

    Private Sub DoReport(stDocName As String)
    Select Case Me!optMethodSelect
    Case 1:
    DoCmd.OpenReport stDocName, acViewPreview

    Case 2:
    DoCmd.OpenReport stDocName, acViewNormal

    Case 3:
    DoCmd.SendObject acSendReport, stDocName
    End Select
    End Sub

    Straight forward enough, but for some reason one report does not work but only when the email option is selected. You can preview it & print, it works normally. But if Email is selected, she breaks with Error 2465: Access can't find the field Forms in your expression.

    What's puzzling me, is how can the exact same report, run with the same data work when previewed and printed, but not with SendObject? Any suggestions? I'm stumped on this one.

    Best Regards,
    Adam
    Last edited by AdamJ; 05-14-03 at 18:00.

Posting Permissions

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