MartyConnelly
martyconnelly at shaw.ca
Thu Oct 27 18:54:59 CDT 2005
I got the basic idea for Google from the TechRepublic article, knowing
basic xml it was easy to modify.
It may not get you as accurate location as buying into something like
MapBlast that might charge 3 cents a map.
but it is free, I don't know how long google will allow this method though.
I think you could get this to work with xmlhttp and an IE popup window
But both methods are more like screen scraping then a true webservice. I
wouldn't consider it truely stable
Jim Lawrence wrote:
>That is absolutely amazing Marty.
>
>Where did you come up with that gem as I had been scouting around and
>nothing similar was uncovered?
>
>This will definitely come in useful.
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
>Sent: Thursday, October 27, 2005 11:38 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] OT: Google Maps API
>
>Here is how to use Access SmartTags to get at Google Maps.
>
>You don't need an API key, You will have to experiment with what you
>put in the Text Field, to get the correct map
>
>Here is a simple method for using Access Smart Tags to display either
>Google maps or weather given a zip code.
>
>if you need it for certain european areas just add or pop the (Text }
>address field comma seperated
>via a http post web service it takes two minutes to add this to an
>Access Mdb
>
>Turnoff MS Word Access or Outlook, that may have the smatrtag engine open
>Make sure that all Microsoft Office XP or Office 2003 applications are
>closed.
>
>Cut and Paste these two xml files below with NotePad into indicated
>paths and save as UTF-8 format not ANSI.
>
>Now in Access
>Select the Tools -> Options... menu to open the Options dialog window.
>Select the "Forms/Reports" tab, then ensure that the "Show Smart Tags on
>Forms" check box on the bottom left of the window is checked. Select the
>"Datasheet" tab, then ensure that the "Show Smart Tags on Datasheets" check
>box on the bottom right of the window is checked.
>
>Select the "OK" button to save your changes.
>
>Choose Tools: AutoCorrect Options. These also may have certain smarttag
>options
>
>Now on your form in design view select the zip code fileld and embed the
>smarttag by right clicking on the smarttag field property
>to build it, the wizard comes up and places the following type of urn in
>the property "urn:schemas-microsoft-com:smarttags:list"
>The wizard looks at the dll's and xml files in C:\Program Files\Common
>Files\Microsoft Shared\Smart Tag\LISTS\
>
>
>Hover your mouse pointer over the form zip code field, click the Smart
>Tag Actions button, and then click Weather by ZIP code.
>or google map, An IE window will now open with your google map.
>
>To link the Customer Name field to the Smart Tag, follow these steps:
>
> # Open the client database table in Design View.
> # Select the Customer Name field row.
> # Click the Builder button next to the Smart Tags field property in
>the field properties window.
> # Click the People check box and click OK.
>
>Now, when the customer service representative uses the form to look up a
>client, a Smart Tag icon will appear next to the client's name. By
>clicking on the Smart Tag's icon drop-down box, the representative can
>add the client to his/her Outlook contacts, send the client an e-mail,
>or schedule a meeting with the client.
>http://techrepublic.com.com/5100-10877_11-5875431.html?tag=sc
>
>
>Cut and Paste these two xml files below with NotePad into indicated
>paths and save as UTF-8 format not ANSI.
>
>C:\Program Files\Common Files\Microsoft Shared\Smart Tag\LISTS\GoogleMap.xml
>
><FL:smarttaglist xmlns:FL="urn:schemas-microsoft-com:smarttags:list">
> <FL:name>Local Map</FL:name>
> <FL:description>Your local map report on Google</FL:description>
> <FL:moreinfourl>http://msdn.microsoft.com/office</FL:moreinfourl>
> <FL:smarttag type="urn:schemas-microsoft-com:office:smarttags#weather">
> <FL:caption>Local Map on Google</FL:caption>
> <FL:terms>
> <FL:termlist>98052,02134</FL:termlist>
> </FL:terms>
> <FL:actions>
> <FL:action id="LocalMap">
> <FL:caption>Map by ZIP code</FL:caption>
> <FL:url>http://maps.google.com/maps?q={TEXT}</FL:url>
> </FL:action>
> </FL:actions>
> </FL:smarttag>
></FL:smarttaglist>
>
>C:\Program Files\Common Files\Microsoft Shared\Smart Tag\LISTS\weather.xml
>
><FL:smarttaglist xmlns:FL="urn:schemas-microsoft-com:smarttags:list">
> <FL:name>Local Weather</FL:name>
> <FL:description>Your local weather report on MSNBC.</FL:description>
> <FL:moreinfourl>http://msdn.microsoft.com/office</FL:moreinfourl>
> <FL:smarttag type="urn:schemas-microsoft-com:office:smarttags#weather">
> <FL:caption>Local Weather on MSNBC</FL:caption>
> <FL:terms>
> <FL:termlist>98052,02134</FL:termlist>
> </FL:terms>
> <FL:actions>
> <FL:action id="LocalWeather">
> <FL:caption>Weather by ZIP code</FL:caption>
>
><FL:url>http://www.msnbc.com/news/wea_front.asp?ta=y&
> tab=BW&tp=&czstr={TEXT}</FL:url>
> </FL:action>
> </FL:actions>
> </FL:smarttag>
></FL:smarttaglist>
>
>
>Jim Lawrence wrote:
>
>
>
>>OT:
>>
>>Google has posted a full API description, with samples, of its Google maps
>>API. (http://www.google.com/apis/maps/documentation ) The only thing you as
>>a user would have to do would be register for an API key. Note that the
>>position within your web site location is very important and can not be
>>moved, once set, hence the use of an iframe to deploy it. See the following
>>detail posted by a disgruntled developer:
>>
>><quote>
>>The most frustrating development with the Google Maps API is that each
>>developer key is limited to a certain hostname and directory. It's
>>
>>
>sensitive
>
>
>>to things like "www.maisonbisson.com" instead of "maisonbisson.com" or
>>"maisonbisson.com/blog/post/10594" instead of "maisonbisson.com/blog/" .
>>That's why this is loading in an iframe.
>></quote>
>>
>>Hope someone will find it useful and be able to add it to their web site or
>>Access application.
>>
>>Jim
>>
>>
>>
>>
>>
>
>
>
--
Marty Connelly
Victoria, B.C.
Canada