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

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
>