Access query coloum string convert to hyperlink

Posted on 2009-02-12
Last Modified: 2013-11-27
I have a query that has a
string coloumn which i want to convert into a hyperlink through query

Any help appreciated

Question by:david_88
    LVL 84

    Accepted Solution

    I'm not clear what your goal is. Do you want to view the query (i.e. in Datasheet view) and have this show up as a hyperlink? If so, you can't do that.

    You can convert the underlying column to a Hyperlink column, if that would work.

    If you want to use this query to drive a Form, then just set whatever control you bind that column to as a Hyperlink.

    So: Ultimately, what do you want to do with this hyperlink?
    LVL 77

    Assisted Solution

    I doubt if this is possible as there is too much conversion involved in getting to a hyperlink.
    Why do you need to do it, anyway?

    Access does not need paths to be set up as hyperlinks in order to use them as hyperlinks.

    For example if the field contains : c:\myfolder\xyz/jpg then when this is displayed in a form in a textbox called txtLink, you can use the textbox's click event procedure to do:

    Application.Followhyperlink me.txtlink
    LVL 44

    Assisted Solution

    To 'see' the composition of a hyperlink field go to the VBA Editor (Alt+F11) and type - hyperlinkpart - and have a good read.
    LVL 44

    Expert Comment

    type - hyperlinkpart - in Help and have a good read.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now