PDA

View Full Version : Generate and Sort Microsoft Access Report with MapPoint Route? VBA



Garindan
03-02-2012, 11:16 AM
I currently have a report in Microsoft Access which is based on a query. It shows the orders for a delivery, including customer name, address, and order details etc. It currently lists them all ordered by postcode and the delivery driver follows, but postcodes are not always the best route, hence why we want to use mappoint.

The report has to be grouped on the order number so it can show all products ordered (more than one per order), so the underlying query will sometimes have an address/customer etc twice or more as theres one record for each product.

I need to add code to the report so it can generate a route for the orders (using house number, street and postcode) and show the results in the report with the orders. Can this be done?

I don't know where to start http://accessworld.accessworld.netdna-cdn.com/forums/images/smilies/frown.gif Preferably I'd like the report to show the orders/deliveries in the correct order as per the route (sorted by route?) with a map of route included somewhere (at end of report?).

The fields I need to generate a route on are 'House_FlatNumber', 'Street' and 'Postcode'.

Many many thanks for any help!!!! http://accessworld.accessworld.netdna-cdn.com/forums/images/smilies/smile.gif

Garindan
03-11-2012, 01:07 PM
Very many thanks to Eric Frost! The hour or so I spent with you on Skype/Teamviewer was very worthwhile, and I couldn't have done it without you! Thankyou!