[AccessD] Any MapPoint programmers out there?

John W. Colby jwcolby at colbyconsulting.com
Fri Jun 3 07:24:06 CDT 2005


Public Function DistanceAsTheCarDrives(Lat1 As Double, Lon1 As Double, Lat2
As Double, Lon2 As Double) As Double
   Dim oLoc1 As MapPoint.Location
   Dim oLoc2 As MapPoint.Location

   Set oLoc1 = mMap.GetLocation(Lat1, Lon1, 0)
   Set oLoc2 = mMap.GetLocation(Lat2, Lon2, 0)

   mMap.ActiveRoute.Clear
   mMap.ActiveRoute.Waypoints.Add oLoc1, "Start"
   mMap.ActiveRoute.Waypoints.Add oLoc2, "End"
   mMap.ActiveRoute.Calculate
   DistanceAsTheCarDrives = mMap.ActiveRoute.Distance
End Function

Ignore the lat/long thing and start with your two locations.

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 Paul Hartland
(ISHARP)
Sent: Friday, June 03, 2005 6:44 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Any MapPoint programmers out there?


The .DistanceTo function seems to return distance as the crow flies....Is
this correct, only I need the actual mileage calculation 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R Mattys
Sent: 02 June 2005 11:25
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Any MapPoint programmers out there?

Since you've said 'postcodes', I'll assume you're in the UK (Not that it
makes a difference at the moment.) You'll be looking to use the .DistanceTo
function

Try here: http://groups-beta.google.com/groups?hl=en&q=mappoint+distanceto

----

Michael R. Mattys
Mattys MapLib for Microsoft MapPoint http://www.mattysconsulting.com



----- Original Message -----
From: "Paul Hartland (ISHARP)" <paul.hartland at isharp.co.uk>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Thursday, June 02, 2005 6:05 AM
Subject: RE: [AccessD] Any MapPoint programmers out there?


> Initially all I want to be able to do is pass a clients postcode and
several
> + employee postcodes into MapPoint and return the miles from client
> + for
> every employee....
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R
Mattys
> Sent: 02 June 2005 10:45
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Any MapPoint programmers out there?
>
> I have been programming in MapPoint for over 2 years using both Access
> and VB6. I have several apps created that I sell, including a full 
> routing and scheduling app.
> Haven't had time to update my website since I started.
>
> My efforts were started at Eric Frost's www.mp2kmag.com, where you'll
> find articles and discussion.
>
> I frequently answer questions on Newsgroups: Microsoft.Public.MapPoint 
> and Microsoft.Public.Street-Trips.
> ----
>
> Michael R. Mattys
> Mattys MapLib for Microsoft MapPoint http://www.mattysconsulting.com
>
>
>
> ----- Original Message -----
> From: "Paul Hartland (ISHARP)" <paul.hartland at isharp.co.uk>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Thursday, June 02, 2005 3:00 AM
> Subject: RE: [AccessD] Any MapPoint programmers out there?
>
>
> > I am also getting ready to use MapPoint with VB6 and SQL Server 
> > 2000,
> mainly
> > want to use it to calculate distances that our employees are from 
> > our clients, but may also want to be able to create maps/directions
etc....
> >
> > So if anyone knows any good sites or can help me with getting 
> > started I would be grateful....
> >
> > Thanks in advance for any help on this....
> >
> > Paul Hartland
> >
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W.
> > Colby
> > Sent: 01 June 2005 23:29
> > To: 'Access Developers discussion and problem solving'
> > Subject: [AccessD] Any MapPoint programmers out there?
> >
> > I'm getting ready to do some pretty serious MapPoint stuff and 
> > wondered if anyone else out there is doing MapPoint?
> >
> > John W. Colby
> > www.ColbyConsulting.com
> >
> > Contribute your unused CPU cycles to a good cause:
> > http://folding.stanford.edu/
> >
> >
> > --
> > 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
> >
>
> --
> 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

--
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