I am a novice programmer and I don’t know if what I want to do is even possible with MapPoint.
I want to use the MapPoint control on an Access form and display all the addresses (with pushpins) within a query on it.
Then I want to select some of the pushpins then export that recordset (dataset?) in some way (excel or into a temporary Access table).
Then display those stops on a new map (or a cleared map) and then display addresses contained in two other queries.
Then I want to build a route, optimize and then export that combined recordset (dataset?) some way (into excel or a temporary Access table) so I can print a report.
I would really like for the records to be in the order they appear in the route. So the report prints in stop order.
And I want to use VBA. I know a little bit of VB.NET but I really want to stay inside Access.
I have already bought the MapPoint for Dummies, and almost all the code is for VB6. I don’t know the first thing about C# so I don’t think the new “Programming MapPoint in .NET” will help me much.
I have looked at the MSDN stuff on MapPoint and I havn’t found anything on exporting data except to excel and then only what you capture in a rectangle and not the route and it doesn’t preserve the order.
Any help would be much appreciated, even if you direct me to an article or a reference for me to read.
Thank You