Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Fri Aug 7 13:31:39 CDT 2009
Hi Mike and Max, Thank you for your feedback. Not sure yet here what(how) I wanted to solve my task, which should behave something like this sample: http://graargh.returnstrue.com/rajdeep/maps/tools/latlong_tool/v7/lat-long-t ool_v7.html but with "clicked" location information "feeded back" to MS Access host form's VBA code and then stored to MS Access database as well as MS Access form "setting the scene" (current map) and "drawing bubbles" on that map for selected on MS Access form's controls locations, and presenting information on what property/geoobject is situated "under the bubble" .... Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mike Mattys Sent: Friday, August 07, 2009 8:43 PM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [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 > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4315 (20090807) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru