Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

Generate and Sort Microsoft Access Report with MapPoint Route? VBA

This is a discussion on Generate and Sort Microsoft Access Report with MapPoint Route? VBA within the Development forums, part of the MapPoint Desktop Discussion category; I currently have a report in Microsoft Access which is based on a query. It shows the orders for a ...

  1. #1
    Garindan is offline Junior Member White Belt
    Join Date
    Mar 2012
    Posts
    3

    Generate and Sort Microsoft Access Report with MapPoint Route? VBA

    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 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!!!!

  2. #2
    Garindan is offline Junior Member White Belt
    Join Date
    Mar 2012
    Posts
    3

    Re: Generate and Sort Microsoft Access Report with MapPoint Route? VBA

    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!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generate intermediate waypoints from a route - how?
    By Gizz in forum Bing Maps and MapPoint Web Service
    Replies: 3
    Last Post: 07-09-2007, 07:23 AM
  2. how to generate url for map directly from microsoft site ?
    By shai_ban007 in forum MP2K Magazine Articles
    Replies: 0
    Last Post: 02-01-2007, 01:41 AM
  3. Generate a Route Automatically from Access SQL Data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-01-2005, 01:25 PM
  4. Embedding a map in an Access report
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-14-2002, 10:27 AM
  5. route report
    By frankkk in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 09-24-2002, 03:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127