Using google maps with microsoft access. Anyone ever use this or understand this:
http://www.issociate.de/board/post/268098/Using_Google_Maps_In_MS_Access.htmlI was good up until this point:
Save and close the new module naming it "Google Variables".
At this point, I will show you how Google Maps structures the URL that
retrieves a requested map.
Let's say you want to search for :
John Smith
111 West Gable Lane
Dayton, OH 45410
When you go to Google Maps at
http://maps.google.com, you type in the
address and Google goes to...
"
http://maps.google.com/maps?q=111+West+Gable+Lane+Dayton+OH +45410&iwloc=A&hl=en"
Now to pass this value to your new form, set your MyGoogleMapURL
variable to the above URL and open the new form like this:
MyGoogleMapURL =
"
http://maps.google.com/maps?q=111+West+Gable+Lane+Dayton+OH +45410&iwloc=A&hl=en"
DoCmd.OpenForm "frmGoogleMap", acNormal
Obviously, you can parse the string value of the URL to any address of
your choosing.
Programmer's Note(s) And/Or Warnings:
If you're connecting to your new Google Maps form through a Citrix
connection, the opening of the Microsoft Web Browser control will crash
your MS Access database. This is because Google Maps will turn your
SpeedScreen setting on in Citrix, even if you have it set to Off, and
the combined running of both creates a GPF error.
You CAN, however, use a standard Remote Desktop Connection(RDC) or a
VNC connection with no resulting crashing of MS Access.
For additional business purposes, you can also have your MS Access
application target different types of businesses nearby (Example :
Schools) just by setting the URL string value to something like...
"
http://maps.google.com/maps?q=schools+loc%3A+111+West+Gable +Lane+Dayton+OH+45410&f=l&
hl=en"
I hope this helps you in your development process.
Start Free Trial
