Share via

Hyperlink in Access report

Anonymous
2013-10-25T18:00:23+00:00

I have an Access report that includes hyperlinks to external documents.  When using Access 2003 I simply converted the report to RTF so the links would work.  Despite my searches here and on the web I have not been able to find out how to do the same thing with Access 2010.  I publish this report each week to the entire company and it is important that the hyperlinks to the external documents work.  Please help!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-10-26T13:45:57+00:00

    I can't be absolutely certain this will work in Access 2010 as I'm using 2007, but you'll find a file InvoicePDF.zip in my public databases folder at:

    https://skydrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

    If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

    If you amend the code in the Click event procedure of the button to Create Invoice as PDF as follows:

                strFullPath = varFolder & "" & Me.Customer.Column(1) & Me.InvoiceNumber & ".rtf"

                ' ensure current record is saved before creating PDF file

                Me.Dirty = False

                DoCmd.OutputTo acOutputReport, "rptInvoice", acFormatRTF, strFullPath, True

    this will create a RTF file from the report rather than a PDF file.

    Was this answer helpful?

    0 comments