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.

Welcome to Utter Access ! Is the datatype for the textbox set to hyperlink at the table level?

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,

37thCt.pdf#FlatDrawings/Plats/37th%20Ct.pdf#


I'm wondering if I need to use a label instead of a text box, I'm really not sure.

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?

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.

HTH

I have attached a sample of the database here.

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.

tblDrawings
drawingId
drawing
etc.





Edited by: jmcwk on Tue Feb 20 19:53:27 EST 2007.

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.

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.

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

HTH

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.
-erik

Erik,

Your quite welcome however what is GIS? and a Thanks as you expressed is payment enough

Good Luck With Your Project !

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.

Thanks again.

Sounds pretty exciting, Thanks for the Info and Have A Good Day!

Click the blinking flag at the top right of the screen