View Full Version : Draw Circles from Addresses v2.0

Eric Frost
04-17-2012, 12:25 PM
NOTE: A new version of this tool is now posted here -- http://www.mapforums.com/draw-circles-addresses-v3-0-a-27621.html#post52244
Variants of this tool have already appeared in the MapForums Downloads section.


In this new one, it draws a Pushpin and Radius for each address, and it now lets you specify more parameters than ever, notably Country.


This should now work with both the NA and EU versions, and in multiple countries in one pass.

Lots more could still be done with the tool. Only a limited number of colors are supported.

The ZOrder could be specified as well as have an option not to draw the Pushpin.

Also, in the version attached, you always have a line. Actually if you have a Fill, MapPoint would allow you not to actually have any line, but this tool does not have a way to do that. (Nonetheless, you could make it a thin line with the same color as the fill which would accomplish the same thing.)

Anyway, now I'm rambling. Try it out and let us know how it works for you and if you have any requests.

Download here -- 697


02-01-2013, 09:35 AM
This file has been quite useful for us. However, is there any way to toggle the circles after they have been created? Using the hide feature only makes the pushpin disappear and not the circles?

Eric Frost
02-03-2013, 10:59 AM
Great! Thanks for the feedback.

There's no way to "Hide" shapes in MapPoint.

You can delete them, but then you have to re-create them.

Is that OK? What if I give you a tool to Delete all shapes on a map? Would that accomplish what you need?


02-04-2013, 08:25 AM
That might be useful. Also, I'm getting an error when I click the Map It button that says:

Run-time error '-2147217383 (80041019)':
Method 'FindAddressResults' of object '_Map' failed

Any suggestions?

Eric Frost
02-04-2013, 09:42 AM
I'd have to troubleshoot this for you. Is it hanging up on a specific address or does it always give this error?

02-04-2013, 10:44 AM
Always giving this error. Whenever I import this data set (without using the circles template) there is a bunch of unmatched data that I have to manually match. I'm guessing that this is what may be throwing the error code, but I'm not certain. How does the code handle unmatched/unfound addresses?

Eric Frost
02-04-2013, 02:06 PM
Thanks for sending me your file, I took a look and saw it working down the list and getting stuck at a P.O. Box.

To get past this, I added a couple lines of code around the FindAddressResults line, see below.

This way it will just it should just ignore any it cannot find.

On Error Resume Next
Set objLoc = objMap.FindAddressResults(szAddress, szCity, , szState, szZip, szCountry)(1)
On Error GoTo 0

hope this helps!

By the way, how are you using the tool for your business? Would you be interested in writing up some paragraphs to share your MapPoint Story and be published in an upcoming MP2K Magazine newsletter?