Creating query hyperlink field

Topic

New Reply

Access 2007 SP2

Select query which returns a concatenated cell with preset filepath and the filename from a table.
how can I make this result into a hyperlink without using an update or append table query?
the sql is:

SELECT
a.Document_Link_Ref,
a.Document_ID,
“#\temp scans” & Trim(.[Document_Filename]) & “#” AS MyLink
FROM dbo_Document_Links as A INNER JOIN dbo_Documents as B ON a.Document_ID = b.Document_ID
WHERE (((a.Document_Link_Ref)=”000277491-A”));

TIA

Reply | Quote

Replies

It would be great if you could, but I do not think you can do this at query level.
However, if you present the query data in a Form in DataSheet view with the underlying control
having it’s Is HyperLink property set to yes it ought to work.

Query Result

Field Property on Form

Datasheet Form with Hyperlink

Reply | Quote

Thanks Andrew, form version works fine.

Reply | Quote