<div>
Thanks for the comment Jeff. &nbsp;Much appreciated.<br />
<br />
I am looking to do this in a loop, not manually, so I guess there is not really any way to automate this process. &nbsp;Maybe time to go back to the drawing board and see if there is any other way that it could be done. &nbsp;Probably not. . .
</div>


<div>
&lt;I am looking to do this in a loop, not manually,&gt;<br />
...meaning you want to see multiple addresses in one screen?<br />
<br />
AFAIC, you cannot do this in MS Access directly.<br />
Again, ...you will have to look into hooking into MapPoint or Google Maps...<br />
Not easy if you are new to coding...<br />
Also, ...most of the code to do this is mainly for .net and other web development platforms, ...not really for MS Access VBA...<br />
:-(<br />
<br />
Jeff
</div>


<div>
Thanks for the feedback. &nbsp;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. &nbsp;<br />
<br />
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. &nbsp;Perhaps time for a new question . . .
</div>


<div>
&lt;I wonder if there are other tools that could be used to develop an automated way to generate images of property addresses. &gt;<br />
As I stated, you can hook into Google Maps and/or MapPoint using their API's/SDK's...<br />
<br />
But again, it may not be &quot;easy&quot; if you are a non programmer...<br />
<br />
Just FYI...<br />
<br />
Jeff
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.<br />
<br />
Can this be done? &nbsp;Any suggestions?
</div>
</div>


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?

Display geocoded viewport image in MS Access report

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.