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

Filtering pushpins..Updating MapPoint by Microsoft Access

This is a discussion on Filtering pushpins..Updating MapPoint by Microsoft Access within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi there, Map Point is quite new for me and the company that I work for has just shown interest ...

  1. #1
    Rodde is offline Junior Member Yellow Belt
    Join Date
    Aug 2005
    Posts
    16

    Filtering pushpins..Updating MapPoint by Microsoft Access

    Hi there,
    Map Point is quite new for me and the company that I work for has just shown interest to use it in order to improve orientation and time management when driving through sales territories. So now it is my job to find out a few features of this program. I hope they exist and would be pleased if you guys could help me out on this.

    First, it would be great if there was an easy update by means of Microsoft Access (Excel would be ok as well...Access preferred though). Updating refers to all outlets of a certain sales territory. There is an Access Query File including all important information on size...address...channel etc of each outlet. In course of time some outlets may close down or switch location for some reason......now the question is whether there is any way to EASILY update those changes on the map with the help of Microsoft Access. To let you know: Information on new outlet locations are going to be passed on by those responsible for the outlet. New Zip Codes etc will be typed in Excel tables which are linked to a main Microsoft Access file (Queries!!). How to get that updated Access data on the map? If possible, in just one or two simple steps.........it would be great if Map Point did that update automatically when starting the program.

    Second Point: Well, as already said above, the region of impact is divided into several sales territories. Referring to outlet updates in this region...is there any other way then creating lists for each territory? Saying that the updated information (Excel) can be directly attributed to each territory without having to create additional Access tables.

    Third: How to filter Pushpins? Any possibility? When focusing on e.g. petrol stations I just would like to see petrol stations and no other institutions labeled by pushpins....

    Fourth point: Most sales manager tempt to visit several outlets on a tour through a territory. So to speak we are dealing with a chain of different stops......is Route Planner able to optimize this chain by appointing the most efficient/shortest route without gong back and forward all the time and not dealing with a redundant stretch of way respectively?


    Every answer would be very helpful to consider Map Point as a contribution to save costs and time!!!

    Best regards.....
    Steven

  2. #2
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    Hi Steven,

    All the 4 points can easily be covered by Mappoint.
    Just begin your project and a lot of people here will be pleased
    to share their experience for some precise questions.

    If you want to save time, begin with this book. It is not expensive and
    you will have a lot of examples to be started.

    http://www.mp2kmag.com/mp4dummies.asp

    My main job is not programmer and I've learned to use Mappoint in
    4 weeks with a very useful project for my business. And I am still learning here.

    Good luck

  3. #3
    calv1ns's Avatar
    calv1ns is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    91

    Another Option

    A lot of what you want is not so hard to do but takes time to get a "production" version you can release to Joe and Jane user. You might want to take a look at a MapPoint add on called Data2Map. It will do all of your points without programming. You can find the product at:

    http://www.data2map.com/

    I can arrange to get you a 15 day demo copy if you like. PM me with your email address. The product costs around US$249.95.
    Calv1ns

  4. #4
    Rodde is offline Junior Member Yellow Belt
    Join Date
    Aug 2005
    Posts
    16
    Hi...
    thx for your replies..unfortunately I live in Europe and not in the US...don`t think there is such a book for Europe......
    I think I found out the way how tom update the data ( by simply linking the source access file)...but I`m still not sure on how to filter the pushpins....could you please give me a hint for that one please?
    Thx in advance..yours...Steven

  5. #5
    paulus is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    7
    Quote Originally Posted by Rodde
    Hi...
    thx for your replies..unfortunately I live in Europe and not in the US...don`t think there is such a book for Europe......
    I think I found out the way how tom update the data ( by simply linking the source access file)...but I`m still not sure on how to filter the pushpins....could you please give me a hint for that one please?
    Thx in advance..yours...Steven
    I had the same problem. Just make an another worksheet in excel where you have only your petrol stations(with a simple excel formula you can easily filter these clients. then just load that specific worksheet into mapPoint and you have all your petrol stations mapped

    good luck

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help please withActivex control and Microsoft Access VB bug?
    By Martin Neighbours in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-04-2011, 02:40 PM
  2. Microsoft CRM integration: Oracle database access from MSCRM
    By Anonymous in forum News and Announcements
    Replies: 0
    Last Post: 02-20-2005, 06:51 PM
  3. Connection between Microsoft Access and MapPoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-06-2004, 07:55 AM
  4. Import a Table From Microsoft Access
    By awiora in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-21-2003, 08:51 AM
  5. programming map point 2002 with microsoft access
    By frankkk in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-25-2002, 08:21 AM

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