[dba-VB] "Google Maps Navigator" Sample MS Access Application

Mike Mattys mmattys at rochester.rr.com
Fri Aug 7 11:43:13 CDT 2009


Hi Max,

Imagine if you could do all of it in Access, though.
Seems like AJAX could be duplicated through VBA or WSH,
which are client-side, instead of Javascript and XMLHTTPRequest
-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-

----- Original Message ----- 
From: "Max Wanadoo" <max.wanadoo at gmail.com>
To: "'Discussion concerning Visual Basic and related programming issues.'" 
<dba-vb at databaseadvisors.com>
Sent: Friday, August 07, 2009 12:21 PM
Subject: Re: [dba-VB] "Google Maps Navigator" Sample MS Access Application


> Shamil, I *think* Google provides a lot of APIs for this sort of stuff.
>
> Max
>
>
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Shamil
> Salakhetdinov
> Sent: 07 August 2009 11:44
> To: 'Discussion concerning Visual Basic and related programming issues.'
> Subject: [dba-VB] "Google Maps Navigator" Sample MS Access Application
>
> Hi All,
>
>
>
> Have you ever tried to work with Google Maps in MS Access application via 
> MS
> Web Browser control?
>
> To do some simple navigation you can use URLs like the following:
>
>
>
> Finland
>
> http://maps.google.com/maps?type=photo
> <http://maps.google.com/maps?type=photo&mode=preview&ll=65,27&spn=5,5>
> &mode=preview&ll=65,27&spn=5,5
>
>
>
> Using this approach I have made a simple sample application, which
> screenshot you can see here:
>
>
>
> http://shamils-4.hosting.parking.ru/temp/GoogleMapsNavigator.jpg
>
>
>
> My question is: Do you know what format of URLs to use to show just a map?
>
>
>
> I know there exist the Google Maps API
> (http://code.google.com/intl/en-EN/apis/maps/) for advanced usage of 
> Google
> Maps via JavaScript but I wanted to try to bypass usage of that API this
> time.
>
>
>
> For the ones interested to experiment via simple Google Maps navigation
> approach I have posted MS Access sample application here:
>
>
>
> http://northwind.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=26600
>
>
>
> You can download it using the following URL(watch line wraps):
>
> http://northwind.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=26600#D
> ownloadId=78352  (175KB)
>
>
>
> Our Northwind.CodePlex.com team could use the above approach + Google Maps
> API in .NET sample application.
>
>
>
> More advanced question is: Is there any way to react in MS Access hosting
> form's VBA code to the changes done in Google Maps map, e.g. Zoom-in/out,
> Move of map .? I mean when Zoon-in/out happens there should be AJAX 
> (Google
> Maps API) calls to the Google server - are there any web browser events,
> corresponding to that API calls?(I know Browser navigation can be trapped
> via web browser events but this isn't the question.)
>
>
>
> Thank you.
>
>
>
> --
>
> Shamil
>
>
>
> P.S. Some more sample URLs:
>
>
>
> Finland
>
> http://maps.google.com/maps?type=photo&mode=preview&ll=65,27&spn=5,5
>
>
>
> UK
>
> http://maps.google.com/maps?type=photo&mode=preview&ll=55,-3&spn=6,6
>
>
>
> Mexico
>
> http://maps.google.com/maps?type=photo&mode=preview&ll=23,-102&spn=10,10
>
>
>
> Italy
>
> http://maps.google.com/maps?type=photo&mode=preview&ll=41,12&spn=5,5
>
>
>
> Australia
>
> http://maps.google.com/maps?type=photo&mode=preview&ll=-25,133&spn=20,20
>
>
>
> Japan
>
> http://maps.google.com/maps?type=photo&mode=preview&ll=36,138&spn=5,5
>
>
>
> Madagascar
>
> http://maps.google.com/maps?type=photo&mode=preview&ll=-18,46&spn=10,16
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 




More information about the dba-VB mailing list