|You can use Google Maps with an Acess DB||Wayne-I-M||1/22/08 6:17 PM|
How to open a Google Maps showing a location from your database.
Not sure if anyone is interested but it was asked a couple of days ago and I
To open Google Maps with the pointer placed on any location in your database.
Create a button on your form (called MapSearch) put this OnClick
Private Sub MapSearch _Click()
You can refine this code
|RE: You can use Google Maps with an Acess DB||Tom Wickerath||1/23/08 1:57 AM|
Sorry to burst your bubble, but the UK is not the center of the universe
Here is my contribution towards your Google Maps endevors:
Option Compare Database
Sub GoogleMap(strStartingPoint As String, strDestination As String)
' Given a FROM address and TO address, will start Internet Explorer,
' Example of calling from Immediate window to get directions from
' Call GoogleMap("1600 Pennsylvania Avenue, Washington, DC", _
Dim strURL As String
'Convert spaces to + sign
strURL = "http://maps.google.com/maps?f=d&hl=en&saddr=" _
Public Function Mapper_Click _
' Call Mapper_Click ("Seattle", "WA", "400 Broad St", "98109")
On Error GoTo Err_Mapper_Click
Dim strFullAddress As Variant
strFullAddress = strAddress & "&city=" & strCity _
strMapquest = "http://www.mapquest.com/maps/map.adp?searchtype=" _
'Remove trailing spaces
'Change imbedded spaces with plus signs
Application.FollowHyperlink strMapquest, , True
strMapquest = vbNullString
|RE: You can use Google Maps with an Acess DB||Wayne-I-M||1/23/08 2:11 AM|
> Sorry to burst your bubble, but the UK is not the center of the universe
I agree - this is :-)
Call in for a cappuccino at any time
The code I made was specific to our needs (we don't need the from / to). We
Mind you - not today (or for the next 6 weeks until then end of March) as I
|RE: You can use Google Maps with an Acess DB||Wayne-I-M||1/23/08 2:22 AM|
Hi again Tom
Just for you (not sure if you're in the US) I have altered the code to give
For the USA - You need a textbox called ZipCode somewhere on the form and a
Private Sub MapSearch_Click()
strGoogleLoaction & "&ie=
|RE: You can use Google Maps with an Acess DB||Tom Wickerath||1/23/08 2:22 AM|
> Call in for a cappuccino at any time
Did you see the second function, named "Mapper_Click"? This sounds similar
|RE: You can use Google Maps with an Acess DB||Tom Wickerath||1/23/08 2:56 AM|
Yep, I'm in the US.
Ummm.....I hope you aren't the one busy marking your own posts as helpful.
|RE: You can use Google Maps with an Acess DB||Wayne-I-M||1/23/08 3:11 AM|
I "always" make a point of clicking Helpful when someone answer one of my
questions - and I have asked some "really" stupid question :-)
I don't think you can click your own posts - never tried but just assumed.
Maybe (like happens on some of our company websites) someone is mes around.
Oh well it well it make them happy.
I have noticed an error in the code - quite simple to change though. You
I did look at the MVP site about the google thing before I did my own but it
Much of the google "stuff" is based on geolocations and API scripts and I
Off to work now - got another happy bunch of people wanting to learn how
|Re: You can use Google Maps with an Acess DB||Larry Linson||1/28/08 1:38 AM|
"Tom Wickerath" <AOS168b AT comcast DOT net> wrote
> Sorry to burst your bubble, but the UK is not
Actually, it may well be, Tom.
I know for a fact that my hometown, Palestine, Anderson County, Texas is the
|RE: You can use Google Maps with an Acess DB||Josh||2/13/09 9:40 AM|
We're a Microsoft-only shop. Has anyone done this using Microsoft Live Maps,
Microsoft Virtual Earth, Microsoft Streets & Trips, or other Microsoft
If so, can you point me in the right direction or provide some sample code?
|RE: You can use Google Maps with an Acess DB||roccogrand||2/13/09 10:58 AM|
I found the following code to display an address in VE. (I use Access 2007.)
Function OpenMap(Address, City, State, Zip, Country)
Dim strAddress As String
Explanation: the address parts are in my table.
I can't remember where I found the code but it works. I am now adding it to
I am also looking for additional code because I would like to map more than
|RE: You can use Google Maps with an Acess DB||Josh||2/13/09 12:48 PM|
Thanks! I'll see what I come up with.