Robert Gracie
Subscriptions at servicexp.com
Fri Dec 3 16:13:24 CST 2004
Sent you a working example to your personal e-mail. Have Fun..... Robert Gracie www.servicexp.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Friday, December 03, 2004 12:54 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Mappoint and Access Gustav, Thanks, that first link had code (working SIMPLE database) for mapping two points. COOL STUFF! The entire code is a single function of maybe 60 lines. And it WORKS! Well, I will have to poke around and see if I can read the distance calculations directly from an object property. It gives me the typical driving directions though so if worst comes to worst, I can just paste that to get the info I need. You da man! John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, December 03, 2004 11:54 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Mappoint and Access Hi John Marty posted this a couple of years ago: How to call MapPoint from Access, Word or Excel http://www.mp2kmag.com/articles.asp?ArticleID=39 Where did MapPoint 2000 Come From? http://www.mp2kmag.com/articles.asp?ArticleID=3 /gustav >>> jwcolby at colbyconsulting.com 03-12-2004 17:28:29 >>> Does anyone have any experience automating mappoint using Access. I have a client that wants to "staff contracts", and in order to do that they want to visualize distances between the person's home address and the work address. They also want to do things like ask mappoint to calculate distance / drive time between a work address and a set of people home addresses, then hand back to Access the data so that Access can display the data in a report sorted on drive time / distance. Stuff like that. Does anyone have code that does this kind of stuff, or know of a web site or user's group that I could go look at to start boning up on this stuff? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com