MapPoint: Distances traveled within a state <p>I would like a process to take two points and build a route between them, and be able to tally miles by state. would a process like this be possible within Access VBA or VB.net?</p> <p>So far I am able to make a route and get the distance, but I am not sure what would be next to find states traveled and the tally of the miles in each state.</p> <p>Here is what I have so far:</p> <pre><code>Public Sub route() Dim objApp As New MapPoint.Application Dim objMap As MapPoint.Map Dim objRoute As MapPoint.route 'Set up application Set objMap = objApp.ActiveMap Set objRoute = objMap.ActiveRoute objApp.Visible = True objApp.UserControl = True 'Add route stops and calculate the route objRoute.Waypoints.Add objMap.FindResults("Iron Mountain, MI").Item(1) objRoute.Waypoints.Add objMap.FindResults("Chicago, IL").Item(1) objRoute.Calculate For Each Item In objRoute.Directions MsgBox Item.Instruction &amp; " " &amp; Item.ElapsedDistance Next End Sub </code></pre> <p>An Issue I am still having is I have tried to use Item.Location.StreetAddress.Region but I get: "Object Variable or With block variable not set." Can anyone tell me how to find the state of a particular direction point? If so I beleive I can find elapsed miles by state by adding elapsed miles - previous elapsed miles to the state it belongs to.</p> <p>thanks!</p>