Dervie hyperlink from data in table

[Wrathchild]

I have a field that has data like "documentname#c:\documentname.doc#" stored as text and I would like to convert that so it shows as a hyperlink in a query. I didn't build the table and I'm trying to do this without modifying the table for certain reasons. Could I possible convert this so it shows "documentname" in the query and is a hyperlink to the path? I wonder if a function could be called to modify it.

 

[Remou]

I am not quite sure what you want to do. A hyperlink field in a table looks like this:
"documentname#c:\documentname.doc#"
And if a query is created using a hypelink field, it will show that field as a hyperlink. If a field that was a hyperlink field has been changed to a text, you can still use it for a hyperlink, but it is a bit more awkward and this cannot, I think, be done in a query. I do not like hypelink fields. I would prefer text fields with Followhyperlink or such like.

 

[Wrathchild]

yeah, I was just wondering if I could mimic data stored as a hyperlink with my data stored as text and have it show as a link in the query results. I've never heard of being able to do this, but you never know.

 

[Remou]

It is easy to do with a form, but not a with query.

 

[dRahme]

Well, one thing you can do is format the table data properly for a hyperlink field in a query.

Append that and an ID field from the original table to another table with a hyperlink field. Link back to the original table on an ID field.

Query the table with the hyperlink field.

I've had to do that once or twice. It is fairly simple and does not affect the original table.

Hope that helps