Solved

Embed hyperlink in Access Report, then export to PDF

Posted on 2008-10-17
3
1,073 Views
Last Modified: 2013-11-28
I would like to include a hyperlink in my report to an external web site. Once the report is generated I want to print the report to a PDF document using the Acrobat printer so that the links remain in the report so that anyone who views the PDF will be able to click the link to follow it to a web site.

I don't need the link to work within the access report, the link only needs to work once it is in the PDF document.

Thanks.
0
Comment
Question by:BradleyOnTheRoad
  • 2
3 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22747024
BradleyOnTheRoad,

I have not seen this done in Access 2003, becaues hyperlinks are not "Clickable" in Access 2003.
It is possible to insert Hyperlinks in PDF's but you may need a more advanced PDF creation utility (Like the full version of Adobe Acrobat)

It is possible to do this in Access 2007 though. (After you install the Save as PDF add-in)

JeffCoachman

0
 

Author Comment

by:BradleyOnTheRoad
ID: 22747226
I created a report with a hyperlink and printed it to my Adobe Acrobat printer.
In the first case I used a label using the Google URL as the caption and the Hyperlink Address. It exported to PDF and the link worked as expected.
However, when I changed the caption to "Go to Google" it failed to create the hyperlink.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 22761049
Then I guess you will have to leave the caption as is.
;-)

JeffCoachman
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update 21-May-2015: I temporarily removed the source code and the code snippets to make major changes to the program. Regards, Joe INTRODUCTION This Article is a follow-up to the Article entitled How To Rename-Move a Batch of PDF Files Based o…
Inserting page numbers in Portable Document Files not only enhances manageability but also makes them look professional. With numbered pages, the file appears more organized and it becomes easier to search for a particular page. The size and the vol…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now