View Single Post

  #3 (permalink)  
Old 12-28-2004
jharbaugh jharbaugh is offline
Junior Member
White Belt
 
Join Date: Apr 2004
Posts: 4
I didn't think I had described my problem very well either so I'll try again:

I have a map that is linked to an Access database. In the Access database are a list of businesses that we work with. For most of the businesses, a pushpin is placed at the exact location of the business. However, I have found at least two businesses that have different addresses (they are approximately 1/2 mile apart; neither are located where MapPoint placed the pushpins) but MapPoint has their corresponding pushpins overlaying each other.

Upon closer examination, I found that the section of road that both businesses are located at does not have numerical addresses assigned to it by MapPoint. It appears that since MapPoint didn't know the numerical addresses, it placed the pushpins in the center of the unaddressed section of the road.

My question is this: I want to be able to write VBA code to read through the link dataset and based on the matching method used to place the pushpin, print a report of pushpins that are not in the correct location. However, the MatchingMethod property is 7 (geoByStreetAddress) for both correctly matched records and for records where the address couldn't be correctly located. Is there a different property I should be using to determine if the pushpin for the record was placed in the correct location or if MapPoint just placed the pushpin in the center of the unaddressed section of the road? If there isn't a property that will provide me with the information I want, is there another method that will tell me which pushpins were not mapped based on the numerical address?

I hope this clears up my question. Thanks for any assistance that anyone can provide.

Jim Harbaugh
Reply With Quote