Feb 20 2007, 04:57 PM
I have a database in which I have created a form for users to access information. There is one combo box which is used as the contol for the other text boxes. In addition I have a text box which holds a hyperlink to an associated file, this is the cause of my troubles. The control source for this box uses a dlookup to pull the hyperlink field from the table based on the current record in the combo box. It displays the proper record, however, the hyperlink does not work. I get blue, underlined text, that looks like a hyperlink, yet I cannot select it. Any ideas anyone? Thanks.
Feb 20 2007, 05:05 PM
Welcome to Utter Access ! Is the datatype for the textbox set to hyperlink at the table level?
Feb 20 2007, 06:25 PM
Thanks, yes the type is set to hyperlink. I think the issue is that the text box is bound to a combo box and controlled by the current selection in the box. The hyperlink being displayed also includes the display text and path of the hyperlink for example, a pdf named 37th Ct.pdf would appear as,
I'm wondering if I need to use a label instead of a text box, I'm really not sure.
Feb 20 2007, 06:35 PM
No actually a text box is what you want, how are the users entering the hyperlink? Are they using a browse button and then selecting the file?
Can you attach a zipped copy of your DB no larger than 500kb and no sensitive data?
Feb 20 2007, 06:44 PM
May help you as well to look at This Thread
and Boyd's Attachment he uses the followhyperlink method whereas the path is a text datatype rather than a hyperlink datatype and gives you a browse button as well to navigate to the needed file.
Feb 20 2007, 07:45 PM
I have attached a sample of the database here.
Feb 20 2007, 07:52 PM
Your attachment has a linked table so I am unable to view what I need can you reattach with the table included? I am on the way to the house however I will take a look when I get home. May be a couple of hours but I promise you I will get back to you. Did the Link not help?
If you can not attach give me the structure of the table and I will go from there.
Edited by: jmcwk on Tue Feb 20 19:53:27 EST 2007.
Feb 21 2007, 11:54 AM
Sorry to get back to you a day later, I appreciate you taking the time to lend me a hand on this. I neglected to see that I had the table split and linked to a backend. Here is an unlinked sample of it, I have included pdf's for the first three entries in the table.
Feb 21 2007, 11:56 AM
Give me about 30 minutes and I will get back to you
Have not opened your DB yet but do you want the browse button as well?
Edited by: jmcwk on Wed Feb 21 11:58:12 EST 2007.
Feb 21 2007, 01:25 PM
Sorry for taking so long see if the attached works for you, if not let me know. I did not reattach the folder holding the two pdf files just the DB
Feb 21 2007, 02:48 PM
Beautiful, it works great, thanks for all you effort. I wish I could pay it back to you but your knowledge exceeds mine, I'm just a GIS nerd. Thanks alot.
Feb 21 2007, 02:57 PM
Your quite welcome however what is GIS? and a Thanks as you expressed is payment enough
Good Luck With Your Project !
Feb 21 2007, 03:05 PM
GIS is geographic information systems, basically it's digital/computer cartography, but all the elements of the map are attached to a backend database allowing a visual display of data/information about virtually anything.
Feb 21 2007, 03:29 PM
Sounds pretty exciting, Thanks for the Info and Have A Good Day!
Feb 21 2007, 04:26 PM
Click the blinking flag at the top right of the screen
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here