By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,070 Members | 1,718 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,070 IT Pros & Developers. It's quick & easy.

How to create a hyperlink?

P: 6
Hi.
I had a quick look for this question on the site, but couldn't find what I was after.

I have a Form where there are two fields [Taddress] and [Tsuburb]. (if need be there is also a [TGeocode] field

I would like to assist our old analyst by joining the fields [Googlelink] so that they are clickable and will open into google maps. i.e.

="https://www.google.com/maps/place".... [Taddress].... [TSuburb]

Ive seen a few sites where they are having to go into and "build" the hyperlink from a table .

Is there another way of doing it as the form stores about a 1000 addresses? Ive got it to a stage that it will just cut and paste into a browser but figured there must be a way to just click from the link.

Any suggestions and as always thanks for any assistance provided .
Jul 14 '19 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,473
Hi Geoff.

Check out Error 7980: HyperlinkAddress or HyperlinkSubAddress read-only for Hyperlink. If it doesn't solve your problem let us know. It should have everything you need. Good luck.
Jul 14 '19 #2

ADezii
Expert 5K+
P: 8,628
  1. Here is some very simple Code that will Open Google Maps to a specific Address & City. It can easily be adapted to include State, Zip Code, and Country if need be.
    Expand|Select|Wrap|Line Numbers
    1. Public Sub FindOnGoogleMaps(strAddress As String, strCity As String)
    2. Dim strURL As String
    3.  
    4. strURL = "http://maps.google.com/maps?q=" & strAddress & ",+" & strCity
    5.  
    6. Application.FollowHyperlink strURL
    7. End Sub
  2. Sample Call:
    Expand|Select|Wrap|Line Numbers
    1. Call FindOnGoogleMaps("2927 South 15th Street", "Philadelphia")
Jul 18 '19 #3

NeoPa
Expert Mod 15k+
P: 31,473
Hi ADezii.

I believe you may have got the wrong end of the stick on this one. Rather than linking directly, I believe the OP wants to formulate a hyperlink so that it can be clicked on normally from the displayed text.

Always good to see you post anyway of course :-)
Jul 18 '19 #4

ADezii
Expert 5K+
P: 8,628
As you can see, I'm still getting things backwards (sdrawkcab). Good to see you!
Jul 18 '19 #5

NeoPa
Expert Mod 15k+
P: 31,473
: - )
Jul 18 '19 #6

P: 6
Hi and thanks for the input. Im hoping to have a look at this on the weekend and will let know you how it goes (or if I stuff it up lol)

Thanks again for the advice
Jul 19 '19 #7

NeoPa
Expert Mod 15k+
P: 31,473
All good :-)

Let us know how you get on with it.
Jul 19 '19 #8

Post your reply

Sign in to post your reply or Sign up for a free account.