MapForums

I run a small courier company. I have a MS Access 07 database, that I use to track orders and invoice out. What I would like to do is insert (bounded or not)a pane (window) into my order screen. with pick and delivery locations, to get a map, miles, and time information. Anyone out there done something like this. Thank you all, for any help or information.

Hi,

You can add all needed pick and delivery locations as stops in a route and (re)calculate it per vehicle.

If you don't have latitude and longitude coordinates (which I assume) from each stop then you can use FindAddressResults method to get a location.

Note that since mappoint 2006 the Location property has Latitude / Longitude coordinates, so if stops are regulary come back you may consider to store them also in your database to gain time and memory.

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet

There are some example of integration with Access in the articles section on MP2Kmag

MapPoint Articles - MP2K Magazine

__________________