[AccessD] Mappoint and Access

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




More information about the AccessD mailing list