[sandrewskid]

Hi, I have hyperlinks (that open up PDF files) on a continuous form. The hyperlink is created on "Form Current" to a LABEL Control using data (Path and file name) form field on that record.

The problem I am having is that the label on "All the records" changes to the current records hyperlink value. How can I keep each records label the hyperlink for that records hyperlink and not have it update all the other labels from the other records?

Steve from Maine

[Ziggy1]

Post a sample DB so we can look at what you have ( no personal data)

[sandrewskid]

I have created a zip file for you with a stripped down access db that has the form that I need help with and some images to hyperlink, however, the tech-guy site won't let me attach it?

can I email it to you?

[turbodante]

Had you zipped it first?

Then use 'Go Advanced' > 'Manage attachments'

[sandrewskid]

I think I got it, Thanks for your respone, I have created a zip file with a stripped down app (just the form I need help with). I have added a few images you can copy to the root of C: to see how my filedialog works and so that the hyper links work. However, It's the label on the right hand side of each record line that is the hyperlink field. Notice it changes (for all records) to whatever record is the current records which is causing the wrong image to come up if you don't actually click on some other part of that record.

I would like the label(hyperlink) to say what the real image is from the Image file field/path.

feeling kind of stupid, I should know how to do this. Thanks for your help.


Steve from Maine.

[OBP]

If you are trying to put the pdf file name in an Unbound text field on a Continuous Form, it will always display the same name in all of the records. It is an Access bug. The only way that I know to get around it, is to add a filename field to the table and put the name in there.
Perhaps ziggy knows something.

[Ziggy1]

I'll look at it tomorrow, had an all day meeting today....you could also try a List box to open using the selected record.

[Ziggy1]

I agree with ODP the Labels on the continuous forms don't let you specify the unique value to the record, but what is wrong with just clicking on the text box where you have the filename already? this moves the record pointer to the record where clicking on the label doesn't?

I also changed your line for the hyperlink to... Application.FollowHyperlink fnHL

Private Sub Sheet_Image_Hyperlink_Click()


Dim fnHL As String
If IsNull(Me.Sheet_Image_FileName) Then
   Exit Sub
End If

fnHL = Me.Sheet_Image_Path & Replace(Me.Sheet_Image_FileName, " ", "%20")
'Me.lblHLNK.Hyperlink.Address = ""
'Me.lblHLNK.Hyperlink.Address = fnHL
Application.FollowHyperlink fnHL



End Sub

[sandrewskid]

Hey, So what I did was took your guys advice and used the "Application.FollowHyperlink" on the "on-click" event of the text box for the file name and it now works as a hyper link(Before it wouldn't and I could't for the life of me fiqure out why). So I got rid of the label control(hyperlink) all together. Everything is great and wonderful. You guys are the best. Much thanks.

[Ziggy1]

great! glad it worked... "Happy Friday"