Emaling and Printing from Report View RRS feed

  • Question

  • I have a report that I open in acViewReport so that the user can see in continuous view the header, detail and footer scrolling down. They want the view to scroll down and then be able to click Print or email and it will either:

    DoCmd.OpenReport "rpt_ViewAll", acViewReport, , "ID = " & Me.Recordset.Fields("ID"), acDialog

    • Print the report
    • Email that different report

    With the Print button,

    DoCmd.OpenReport "rpt_View_All", , , "ID = " & Me.Recordset.Fields("ID")

    I get an error "This feature is only available in an ADP

    And with the Email Button, it opens the email client allows to print, but then locks access and cant get back into access

     DoCmd.OpenReport strReportName, acViewPreview, , strwhere, acHidden
        Reports(strReportName).Caption = strAttachmentName
        DoCmd.SendObject acSendReport, strReportName, acFormatPDF, strEmail, , , strSubject

    Can I use command buttons in acViewReport or should I use a continuous form instead? and if I use a form, how do I get it so the header scrolls with the detail?

    • Edited by JHarding08 Tuesday, December 24, 2019 5:13 PM
    Tuesday, December 24, 2019 2:32 AM