Access query coloum string convert to hyperlink

Posted on 2009-02-12
Medium Priority
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
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 672 total points
ID: 23622252
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

peter57r earned 664 total points
ID: 23622396
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

GRayL earned 664 total points
ID: 23625706
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

ID: 23625719
type - hyperlinkpart - in Help and have a good read.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

862 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