[AccessD] Any MapPoint programmers out there?

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