Hyperlinks in sub report

[Guest]

I have a sub report that contains a list of pdf file names. Next to each the
file name I have a text box “txtViewPDFâ€. I want to set
txtViewPDF.HyperlinkAddress so that when the user clicks on it the Pdf file
opens.

I’ve encountered a few problems trying to implement this:

First: I can’t click on the hyperlink because the mouse cursor is always a
magnifying glass. Is there a setting I need to change to make the mouse
cursor change from a magnifying glass to an arrow?

Hyperlinks work when I export the report to Word.

Second: I am trying to set the HyperlinkAddress with the following sub but
all the hyperlinks in the sub report open the last pdf file in the sub report
(when exported to word).

The full pdf file path = strDefultPath & strFileName

Private Sub Report_Page()

Dim strDefultPath As String
Dim strFileName As String
Dim strFullPath As String

strDefultPath = Dlookup( )
strFileName = txtFileName
strFullPath = strDefultPath & strFileName

Me!txtViewPDF.HyperlinkAddress = strFullPath

End Sub


Cheers,
Seth

 

[Gina Whipp]

Okay, I hope I explain this correctly, if not someone will correct me. A
report (and/or subreport) is a snapshot (think of it like a picture), you
cannot click on it except to Zoom in or out. And yes once in Word you will
be able to click on the hyperlink.

The action you want to do can be accomplished from a form but I guess you
don't want to do it that way.

 

[Guest]

I have been wondering why anyone would want to put a subform in a report. Is
this a situation where I should do that?

Cheers,
Seth

 

[SA]

Seth:

You can place a form as a subform in a report, however, you still won't be
able to activate hyperlinks when the report is displayed, because Access
shows a graphic representation of the report data and it is not an
interactive object.