Using hyperlinks to build a storage area for files.

[MatthewDavis]

After reading a posting from Trevor at 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.

 

[accesswatch]

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

 

[MatthewDavis]

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

 

[accesswatch]

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
email Trevor@accesswatch.co.uk



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