473,287 Members | 1,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

How to create a hyperlink?

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
7 1845
NeoPa
32,554 Expert Mod 16PB
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
8,834 Expert 8TB
  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
32,554 Expert Mod 16PB
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
8,834 Expert 8TB
As you can see, I'm still getting things backwards (sdrawkcab). Good to see you!
Jul 18 '19 #5
NeoPa
32,554 Expert Mod 16PB
: - )
Jul 18 '19 #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
32,554 Expert Mod 16PB
All good :-)

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

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

Similar topics

5
by: Jon D | last post by:
I have a form where a user enters their name, date etc. i also want them to be able to click on a browse button and select a file which will then appear in a textbox. when they press submit i want...
3
by: The Dana's | last post by:
I need to create a static HTML file that runs only on the local client PC. On the page (say PageA.htm), I would like for a hypelink to another page (Page B) to appear ONLY if the target file the...
2
by: SaT | last post by:
Does anyone know how to create hyperlink labels within a datagrid, on the fly? Thanks SaT
7
by: Beefminator | last post by:
Hello, How can you create a hyperlink in the HTML body of CDOsys email? Line 7 is a link for yahoo.com, but the asp page does not work. Set objMessage = CreateObject("CDO.Message")...
2
by: jagguy | last post by:
I have a column on a grid view I read in froma DB. The field has 2 values true or false. Now if i click on the field i want the gridview and the DB updated to the new value. I click on true on a row...
5
by: theine | last post by:
How do I create Hyperlink based of a specific field in the same row? In Excel it done like this: =HYPERLINK("", A273) where the anything inside the " " is the value it's looking for in that...
10
by: juan503 | last post by:
I am trying to setup a MS Access DB in server side, users can attach (hyperlink) his/her local files to DB that all users can see files, so it should upload selected user's file from his/her computer...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.