[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Access report w/ FollowHyperlink Links Exported to PDF

Posted on 2014-04-22
6
Medium Priority
?
1,295 Views
Last Modified: 2014-05-03
I have an access report with a list of text fields.  I have turned these into hyperlinks using code and an invisible field on my report:

Application.FollowHyperlink "http://www.mysite.com" & [ResourceURL], , True

This works perfectly when I view it in access.  

I'd like to be able to export this report to a PDF and keep the links active.  I could create the actual hyperlink on the report but I don't want the user to see the URL, just the title that appears in my text field.  Is this possible?
0
Comment
Question by:amy_goe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 85
ID: 40016178
I'm not sure if you can to this with the standard PDF export in Access, but then I've never tried to do it. Generally an outputted report is "static", and the user cannot interact with it.

That said, you could always try the standard "href" sort of syntax:

<A href="http:\\www.microsoft.com">Go To Microsoft<\a?

But I don't know if that would work on a PDF
0
 

Author Comment

by:amy_goe
ID: 40016275
I'm not really clear on how I would use the href to export the report to a PDF.

I've come up with a work around by creating the url on the report with the font in the same color as the background and placing it as close to the bottom of the text field in as possible in a small font.  The links work in the PDF and the hand cursor pops when you hover near the text field.  Its not ideal because if you approach the text from the top with your cursor it seems to pop up the pointer a little late but its workable for now.

If anyone has any suggestions on how to do this in a more technically correct way, I'd love to hear....
0
 
LVL 85
ID: 40017102
As I said, I'm not sure you can do this. The PDF option in Access is somewhat limited, and generally if you need functionality above what is provided you must work with 3rd party libraries (like the Adobe SDK).
0
 

Author Comment

by:amy_goe
ID: 40017199
Yes, thanks Scott.  I don't  have the expertise to begin mucking in the adobe SDK.  And without some additional information on where to begin trying with href, I don't know what to do with that.  

I knew my request seemed like a tough one but worth asking.
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40017264
I'm not sure HREF is the right suggestion. The PDF specifications don't mention it, so I don't think it support the same set of features as, say, an HTML or RTF output.

From what I can see, the gist is this - either work with the limited feature set of the native Access PDF engine, or begin learning a 3rd party solution (like the Adobe SDK). I don't really see an alternative.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

650 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