Paul Hartland (ISHARP)
paul.hartland at isharp.co.uk
Fri Jun 3 08:36:46 CDT 2005
Thanks to everyone for their code samples, the day should now fly by with this for me to play with -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: 03 June 2005 13:24 To: 'Access Developers discussion and problem solving' Subject: RE: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com