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 5 of 5

Can MapPoint Do This?

This is a discussion on Can MapPoint Do This? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am a novice programmer and I donít know if what I want to do is even possible with MapPoint. ...

  1. #1
    MrBarefoot is offline Junior Member White Belt
    Join Date
    Sep 2004
    Posts
    3

    Can MapPoint Do This?

    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

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    I think most if not all what you wants is possible with mappoint eather direct with the provided methods eather indirect where you can write it yourself to have some workarounds.

    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.
    Some methods can be limited which is normal, but you have control yourself over the data if you keep it yourself in access, so you can do whatever you wants with it. About the order of a calculated route, I have some applications where I do a route report so I'm pretty sure about the order.

    Any help would be much appreciated, even if you direct me to an article or a reference for me to read.
    I think you can find pretty mutch on this forum. There is a search engine also and there are some articles about VBA I think. And for all other questions just fire them off here

  3. #3
    calv1ns's Avatar
    calv1ns is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    91
    If (when) you get stuck lots of people here will help you with specifics.

    You might want to consider that bargain low price "MapPoint for Dummies" that Eric sells as a starting point.


    Ciao,
    Calv1ns

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    He said he already has MP for Dummies. I think it is a good idea to stay in Access and use VBA, not C#. I program MapPoint a lot in Excel VBA, it is very similar and easy to use. However the C# (.NET) syntax is not much different so I think you might still find the Programming MapPoint in .NET useful to explain different parts of the API. Although the syntax will be a little different, you can still learn how to program those parts of the API by reading it.

    On this site, for Access these two sample apps come to mind --
    http://www.mp2kmag.com/a74--home.locator.mappoint.html
    and
    http://www.mp2kmag.com/a71--pf.chang....mappoint.html
    though I'm sure there are some good ones I am missing.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  5. #5
    calv1ns's Avatar
    calv1ns is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    91
    Sorry Eric - missed that. No commission this time
    Calv1ns

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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