After reading a posting from Trevor at www.accesswatch.co.uk, (http://www.accesswatch.co.uk,) I started to build a storage location for files, base on hyperlinks.
I'm using an active X Common dialog control to capture the path to the file. I then place this path into a field, the field is a hyperlink formatted field. The path stores correctly in the table.

Problem - The hyperlink does not work. Its blue, and underlined, but does not function when clicked on. If I cut and paste the path into the field in the table, it works.
What I'm I doing wrong?

Thanks in advance.

I have had this problem myself. I have not worked out the exact circumstances that it occurs under but as a work around I place the string in a Memo field and then convert the memo field to a hyperlink field either by going into the table and changing the field type or by using an Append query into a table with a hyperlink field. This appears to work. I think it is something to do with the way Access assigns the comment part of the hyperlink.

Hope this helps
I would be interested in knowing hoew you get on wuth this project.
Regards
Trevor from www.accesswatch.co.uk (http://www.accesswatch.co.uk)

Thanks Trevor. I tried an append query from a temp table with a memo field to my real table with a hyperlink field. Still did not work.
But, this did.
In the append query, I put Q100025# in front of the path string, now it works. The only down side, I cannot edit the hyperlink.

Thanks

Hi Mathew.
To edit the Hyperlink you have to right click on th link. The comment is seperate from the Hyperlink.

It looks from your example that you are duplicating the work I am doing. I am preparing a database that contains every Knowledge Base Article with multiple Search and Xref features.
I have all the 97 articles categorised by Keyword and many of the 2000 articles. I am also working on the 97 and 2000 downloads. I am hoping to make this availble very shortly
Drop me an Email to see if we are going down the same track.
regards
Trevor from www.accesswatch.co.uk (http://www.accesswatch.co.uk)
email Trevor@accesswatch.co.uk



[This message has been edited by accesswatch (edited 09-25-2000).]