OK...Here's a tricky one!!!

[FuzzyBear9]

How can I take a text file consisting of a list of file names and convert them into hyperlinks in Access 97?!

I can use an update query to specify both drive and folder of the files, eg:

01056.doc

to

Q\Client\01056.doc


but can I update them as hyperlinks? When I try to modify the column from text to hyperlink, Access specifes the http protocol but duplicates the the line, eg:

HTTP://Q:\01056\WPDATAQ:\01056\WPDATA01056crt.031

What I want to be able to do is allow user to open an index file and click on the relevant hyperlink to that document. I have thousands of documents that will not move from their location. Is it possible?

 

[FuzzyBear9]

Sorry, Access returns the following when I change a text column to a hyperlink column:

Q:\01056\WPDATAQ:\01056\WPDATA01056crt.031

 

[MichaelRed]

Use two Columns? Run an update query to set the hyperlink from the text. MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over