Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    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([b].[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

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    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
    [attachment=89541:HLinkQuery.jpg]
    Field Property on Form
    [attachment=89542:HlinkProp.jpg]
    Datasheet Form with Hyperlink
    [attachment=89543:HLinkForm.jpg]
    Attached Images Attached Images
    Andrew

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks Andrew, form version works fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •