Display geocoded viewport image in MS Access report
I have a list of property addresses that have already been geocoded and the resulting lat, long, and viewport coordinates are now all stored in my database.
What I would like to do now is to design a report that will display a static map image of the property address, using the stored lat long and/or viewport coordinates.
Can this be done? Any suggestions?
What I would like to do now is to design a report that will display a static map image of the property address, using the stored lat long and/or viewport coordinates.
Can this be done? Any suggestions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<I am looking to do this in a loop, not manually,>
...meaning you want to see multiple addresses in one screen?
AFAIC, you cannot do this in MS Access directly.
Again, ...you will have to look into hooking into MapPoint or Google Maps...
Not easy if you are new to coding...
Also, ...most of the code to do this is mainly for .net and other web development platforms, ...not really for MS Access VBA...
:-(
Jeff
...meaning you want to see multiple addresses in one screen?
AFAIC, you cannot do this in MS Access directly.
Again, ...you will have to look into hooking into MapPoint or Google Maps...
Not easy if you are new to coding...
Also, ...most of the code to do this is mainly for .net and other web development platforms, ...not really for MS Access VBA...
:-(
Jeff
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the feedback. Rather than try to harvest the images on-the-fly, I'm going to approach that problem separately and try to see if I can grab the images first.
As much as we love our dear, old MS Access, leaving that aside, I wonder if there are other tools that could be used to develop an automated way to generate images of property addresses. Perhaps time for a new question . . .
As much as we love our dear, old MS Access, leaving that aside, I wonder if there are other tools that could be used to develop an automated way to generate images of property addresses. Perhaps time for a new question . . .
<I wonder if there are other tools that could be used to develop an automated way to generate images of property addresses. >
As I stated, you can hook into Google Maps and/or MapPoint using their API's/SDK's...
But again, it may not be "easy" if you are a non programmer...
Just FYI...
Jeff
As I stated, you can hook into Google Maps and/or MapPoint using their API's/SDK's...
But again, it may not be "easy" if you are a non programmer...
Just FYI...
Jeff
ASKER
I am looking to do this in a loop, not manually, so I guess there is not really any way to automate this process. Maybe time to go back to the drawing board and see if there is any other way that it could be done. Probably not. . .