Recent content by Eric Frost

Just to follow up, here are some new Access VBA and MapPoint examples. The first shows how to geocode or obtain the lat/lon from an address and write it back into MapPoint. Sub Geocode() Dim APP As MapPoint.Application Dim MAP As MapPoint.MAP Dim FAR As MapPoint.FindResults Dim LOC As...

Sorry again for the "mercenary" offer, I'm just not sure what to tell you :-) You see the working examples, can you build off those? If not, do you have a specific question? then I'd be glad to help via the forum! On my side, I am actually quite often or at least a couple times per year where...

I don't mean to sound mercenary, but it this a situation where you'd like to pay someone like me to spend an hour or even just half an hour via shared desktop getting you started? write me at eric.frost AT mp2kmag com

Did you find the Access examples in the articles section of MP2Kmag com? There are also a lot of basic Excel VBA examples, the coding is practically identical to what it would be in Access VBA --http www mp2kmag com / excel Eric

Ahh, good point. For straight line distance calculations I use code grabbed from here -- williams DOT best DOT vwh DOT net/avform.htm See the downloadable spreadsheet with Excel VBA examples. I actually used this code in quite a few projects :-) Eric

Sorry I know this is an old thread, but just in case anyone is searching: No MapPoint does not support ICAO codes, but if you have a table of lat/lon and the ICAO, then you could do it. Also, if you import that table as Pushpins, then you could simply use the FindPushpin method to jump over to...

Maybe I'm not totally understanding the questions, but MapPoint can import from either an Access Query or Table. With more recent versions of MapPoint if you are doing this repeatedly, it seemed like importing from a query was a little flaky so I have resorted to importing from a table (just...