hyperlink for google maps

**[email protected]** · 10-18-2011, 08:31 AM

I am attempting to create a formula with the data setup in the field below to view in Google maps. I have thousands of addresses that I need to reference with google maps. I would appreciate any help to get me through this project. Thanks in advance. Tom

A B C D E
Downing Street 107 Buffalo New York

Cell A Downing (Street Name)
Cell B Street (Street Type)
Cell C 107 (Address Number)
Cell D Buffalo (City)
Cell E New York (State)

**Domski** · 10-18-2011, 08:44 AM

Try something like this:

=HYPERLINK("http://maps.google.com/maps?q="&SUBSTITUTE(A1&"+"&B1&"+"&C1&"+"&D1&"+"&E1," ","+"))

Dom

**[email protected]** · 10-18-2011, 09:10 AM

Thank you so much. Can that be imported into an access database for use? Its works great in excel but when I create a new hyperlink field in access it does not work. Appreciate your help. Thanks. Tom

**Domski** · 10-18-2011, 09:17 AM

Not sure really but I'd assume so. I don't use Access much.

Dom

**mvanarey** · 04-17-2013, 03:06 AM

Hi, thanks for putting that formula up. One further question though - can you adjust the standard zoom level of Google Maps when you click on it?
I used your formula and the link view was too wide as standard. Thanks in advance.

**ObiBenKenobi** · 05-06-2013, 05:13 PM

Hi there,

This reply is in regard to the Access question above. I’ve successfully created a Google Maps button for an application I designed.
It may be more cumbersome than required, but it works…

On my form I have a mess of textboxes, then a button that’s a follow hyperlink of the concatenated website address. (To and from directions).

Self explanatory textboxes (user inputs variables):
[PickUpAddress]
[PickUpCity]
[PickUpState]
[DropOffAddress]
[DropOffCity]
[DropOffState]

Static textboxes:
[BeginHTTP] =http://maps.google.com/maps?f=d&source=s_d&saddr=

[MiddleHTTP]="&daddr="

[COMPLETEADDY]=([BeginHTTP] & [PickUpAddress] & ", " & [PickUpCity] & ", " & [PickUpState] & [MiddleHTTP] & [DropOffAddress] & ", " & [DropOffCity] & "," & [DropOffState])

Button: OnClick [event procedure]:

Please Login or Register  to view this content.

**protonLeah** · 05-06-2013, 05:48 PM

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.