Avatar of Karen Schaefer
Karen Schaefer
Flag for United States of America asked on

Export Hyperlink to a PDF from Access 2007

Is there a way to include the hyperlink in an PDF from an Access 2007 Report, but only display the Employee Name instead of the hyperlink.

ie in the Edit Hyperlink dialog you can display different value (employee Name) and still have the hyperlink attached.

I know I asked a similar question on ee - see : https://www.experts-exchange.com/questions/27904425/Include-a-hyperlink-in-an-Access-2007-Report-that-is-exported-to-PDF.html

There is a attached sample of the Org Chart database.  I would like the Org chart to display the employee name, but allow the user to click on the name in the PDF and have the hyperlink activate.  Is this possible.  I know you can do it in a Report layout, but I must export this to an PDF for viewing on the internal Web.

Thanks,

K
Microsoft AccessMicrosoft ApplicationsMicrosoft Development

Avatar of undefined
Last Comment
Karen Schaefer

8/22/2022 - Mon
Jeffrey Coachman

Do you have the Hyperlink working on the report now?
(If the hyperlink works in the report, it should work in the PDF)

<I would like the Org chart to display the employee name, but allow the user to click on the name in the PDF and have the hyperlink activate. >
Describe in detail what you mean by "Activate"

Is this just a Hyperlink on the report (in a control, ...IsHyperlink=True )
...or is this data from a Hyperlink "field" in the table...

Got a sample...?
Karen Schaefer

ASKER
Acrivate - enable - have the link open to the correct location.

I added a new field to the report for the hyperlink and that exports ok to the PDF, however I do not want to actually display the hyperlink just the employee name.

Similar to the way you can in a form - have the employee name, with hyperlink attached and when you click on the employee name it opens the link and changes the name from black to purple indicating that the person c licked on the hyperlink.

K
Karen Schaefer

ASKER
HERE IS A REVISED SAMPLE
rptOrgChart-Template.zip
OrgChartSample.zip
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Jeffrey Coachman

The PDF contains working hyperlinks, but the Report does not...?

I'm confused...
Karen Schaefer

ASKER
I do not want to display the actual Hyperlink, I want to display just the employee name - when the user clicks on the name I want the hyperlink activated and the user is able to navigate to the URL location.

pic
Jeffrey Coachman

Karen,
I am still confused here
<The PDF contains working hyperlinks, but the Report does not...?>

What exactly am I supposed to be working on...?

Where is the Source for the PDF you posted?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Karen Schaefer

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Karen Schaefer

ASKER
User changed mind on functionality