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

Latitude/Longitude Address on Map

This is a discussion on Latitude/Longitude Address on Map within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi Hope someone could help, I have an access data base that has all my customer addresses on a Table ...

  1. #1
    lookatthis is offline Junior Member White Belt
    Join Date
    Nov 2005
    Posts
    1

    Latitude/Longitude Address on Map

    Hi Hope someone could help,

    I have an access data base that has all my customer addresses on a Table and would like to add a latitude and Longitude to the table to pin point the customer location as I understand this is the best way to make sure customers donít overlap each other, also it there a way or code to place on the event procedure on click of a button in Microsoft Access to export customer address and pin them on Map Point? I would like to be able to export more then on load number, for example each customer has a Load # (150) and Stop # (111) the load number represents a Truck and what I would like to do is in some way to export more then one load at time and map it on one click. If you could help it would be greatly appreciated.

    Thanks

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

    I'm not sure I understeand your question completely, but I understeand that you wants to program in VBA to display your customar locations on the map. I type example in C# because if I should do it in VB then I will type too many syntax errors

    There is a method:
    Code:
    FindResults results = mp.ActiveMap.FindAddressResults(street, city, othercity, region, zip, country);
    Which returns a collection of Location objects. This Location object can be used to put a push pin on the map, like this:

    Code:
    if &#40;results.ResultsQuality <= GeoFindResultsQuality.geoAmbiguousResults&#41;
        foreach &#40;object o in results&#41; &#123;
            Location Loc = o as Location;
            if &#40;Loc != null&#41; &#123;
                Pushpin PP = mp.ActiveMap.AddPushpin&#40;Loc, ""&#41;;
                return;

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to get latitude and longitude
    By ma2005pp in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 09-28-2005, 02:57 AM
  2. Latitude and Longitude
    By virgilar in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-21-2005, 02:01 PM
  3. Latitude and Longitude
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-25-2003, 01:52 PM
  4. NMEA latitude/longitude and mappoint latitude/longitude
    By muurman in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 11-22-2003, 05:42 AM
  5. Convert address to latitude/longitude
    By jia_1980 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-21-2003, 05:42 PM

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