Database updates are currently taking place!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
 
Business Applications
Tag Cloud
acer audio boot bsod compaq computer connection crash dell driver drivers dvd error firefox format freeze game hard drive hardware install internet itunes laptop linksys macro malware network outlook outlook 2003 outlook 2007 password problem redirect server slow sound spyware toshiba trojan usb video virus vista windows windows 7 windows 7 64 bit windows vista windows xp wireless youtube
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Help with hyperlinks on Continuous Forms

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

 
Thread Tools
sandrewskid's Avatar
Junior Member with 5 posts.
 
Join Date: Dec 2009
Location: Main
Experience: System Stylist
09-Feb-2010, 10:14 AM #1
Help with hyperlinks on Continuous Forms
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's Avatar
Computer Specs
Senior Member with 1,939 posts.
 
Join Date: Jun 2002
Location: Ontario,Canada
Experience: Intermediate
09-Feb-2010, 04:03 PM #2
Post a sample DB so we can look at what you have ( no personal data)
sandrewskid's Avatar
Junior Member with 5 posts.
 
Join Date: Dec 2009
Location: Main
Experience: System Stylist
11-Feb-2010, 08:23 AM #3
Hello
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's Avatar
Senior Member with 552 posts.
 
Join Date: Dec 2008
Location: GMT UK
11-Feb-2010, 08:32 AM #4
Had you zipped it first?

Then use 'Go Advanced' > 'Manage attachments'
sandrewskid's Avatar
Junior Member with 5 posts.
 
Join Date: Dec 2009
Location: Main
Experience: System Stylist
11-Feb-2010, 09:09 AM #5
Hylerlink on continuous forms
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.
Attached Files
File Type: zip Ziggy.zip (323.0 KB, 3 views)
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 9,929 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
11-Feb-2010, 09:24 AM #6
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.
__________________
OBP
I do not give up easily
Ziggy1's Avatar
Computer Specs
Senior Member with 1,939 posts.
 
Join Date: Jun 2002
Location: Ontario,Canada
Experience: Intermediate
11-Feb-2010, 10:22 PM #7
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's Avatar
Computer Specs
Senior Member with 1,939 posts.
 
Join Date: Jun 2002
Location: Ontario,Canada
Experience: Intermediate
12-Feb-2010, 07:36 AM #8
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



Code:
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
__________________
Ziggy

τΏτ

Last edited by Ziggy1 : 12-Feb-2010 08:34 AM.
sandrewskid's Avatar
Junior Member with 5 posts.
 
Join Date: Dec 2009
Location: Main
Experience: System Stylist
12-Feb-2010, 08:33 AM #9
got it
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's Avatar
Computer Specs
Senior Member with 1,939 posts.
 
Join Date: Jun 2002
Location: Ontario,Canada
Experience: Intermediate
12-Feb-2010, 08:36 AM #10
great! glad it worked... "Happy Friday"
Reply

Smart Search

Find your solution!



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.

Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 06:53 PM.
Copyright © 1996 - 2010 TechGuy, Inc. All rights reserved.
Powered by Cermak Technologies, Inc.