Max Wanadoo
max.wanadoo at gmail.com
Fri Aug 7 11:21:04 CDT 2009
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