Hi all, I have an Access database for customer orders. We would like to output something to Microsoft MapPoint to plan routes for delivery drivers.
Currently I have a form where the database user selects orders to load onto a van, then presses a command button. It outputs to a report for the delivery driver, which lists the orders by postcode.
This is ok but ordered by postcode means the delivery driver sometimes doubles back. So we want to generate a proper route.
So I can just output something from the form in the correct format and import it into MapPoint, or put code on the button to automatically generate something.
I just wondered if anyone has experience with this, or has any idea what would be good to do?
Obviously I have to still give the driver customer details and order details with the generated route.
Many thanks for any help!
Currently I have a form where the database user selects orders to load onto a van, then presses a command button. It outputs to a report for the delivery driver, which lists the orders by postcode.
This is ok but ordered by postcode means the delivery driver sometimes doubles back. So we want to generate a proper route.
So I can just output something from the form in the correct format and import it into MapPoint, or put code on the button to automatically generate something.
I just wondered if anyone has experience with this, or has any idea what would be good to do?
Obviously I have to still give the driver customer details and order details with the generated route.
Many thanks for any help!