Access VBA and Google Earth Desktop

[JGalletta]

I've come to the point in the design of my chemical database where I will be generating recordsets of data which represent fields on a map and the re-entry date of the fields (date at which it is safe to return into a field after spraying a chemical in said field) . I have an ESRI shapefile converted to KML and overlayed on a Google Earth view of the farm. Each polygon in the shape file represents a different field on the farm (standard naming between shape file and db). I'd like to be able to change the color of the individual polygons in the KML file being viewed on the Google Earth desktop in order to print out maps representing restricted access areas. Where do I go about connecting these two interfaces (Access and Google Earth) and does anyone know what language Google Earth runs/where to find forums for Google Earth Desktop (not web API) development/ or do I just manipulate Google's variables from Access...? This will be my first time delving in to Google Earth programming if it is possible, and would like a bit of guidance.

Thanks in advance,
John

 

[Uncle Gizmo]

I don't know anything about this, so I did a little bit of Google and found this link which may or may not be of use to you: http://scripts.downloadroute.com/GPS-Trail-570b2cba.html

I understand that kmL data can be converted to XML data and vice versa, However I don't know if you can use this in the desktop application, I suspect it's for the web application?

 

[JGalletta]

Sorry, but that does diddly squat for me. :-/
Here's a little example of what I need to do:

Say I have this map of my farm in Google Earth as a KML file (what a huge farm!). I need to be able to change the colors of individual shapes on the map from access, based on the names I've given to the shape and a separate piece of data relevant to each individual shape (e.g. type of crop planted). I'm sure someone here knows how to accomplish this. Thanks anyway! If worse comes to worse, I'll utilize the web API and compile a website to print based on what I need. But, I will still need help doing that, as well.

 

[Uncle Gizmo]

Sorry, but that does diddly squat for me. :-/

So I take it you downloaded the script, opened it in a text editor but could find nothing in it that would be of any use?

 

[JGalletta]

I just discovered that KML is actually script (doh!); I'll give that a look. If I do successfully find the variables I need to change in my KML file, how can I open Google Maps from VBA in order to print maps from the changed file?

 

[JGalletta]

Anyone have an answer on how to call up Google Earth from Access?

 

[JGalletta]

I found the KML needed and will build the KML necessary based on query results and concatenating the coordinates and other criteria. But, how do you save/create a KML file from the string once it's built?