If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlinks in sub report
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 |
#2
|
|||
|
|||
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. "Seth" wrote in message ... 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 |
#3
|
|||
|
|||
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 "Gina Whipp" wrote: 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. "Seth" wrote in message ... 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 |
#4
|
|||
|
|||
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. -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Seth" wrote in message news 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 "Gina Whipp" wrote: 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. "Seth" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
Set up a report using more than one query | jbeck2010 | Database Design | 6 | February 12th, 2005 06:59 AM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |