Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    47

    Unanswered: email current record report ? ? ?

    I have a form that when the current record is updated I want the user to send for approval . I can't seem to figure out how to send a report of only the current record ? I can easily send a report with all records , but not the current record active in the form ?

  2. #2
    Join Date
    May 2003
    Posts
    47

    I got it finally !

    Here is what I did in case some other newbie needs this :

    Dim stDocName as String

    stDocName = "Vacation"
    DoCmd.OpenReport stDocName, acPreview, , "[RecordID] = " & Me.RecordID
    DoCmd.SendObject acSendReport, "Vacation", acFormatHTML, "sales@salesfirst.com", , , "Vacation approval request", "Please review the attached vacation request and approve it via the database", False


    This takes the record I am currently viewing and puts only that record into a report then sends the report to the appropriate person for approval .

Posting Permissions

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