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

Access Pushpins

This is a discussion on Access Pushpins within the MapPoint Desktop Discussion forums, part of the Map Forums category; HI, I have an Access Service report file that I have imported into MapPoint. One of the fields contains date ...

  1. #1
    johnnyo is offline Junior Member White Belt
    Join Date
    Aug 2002
    Posts
    1

    Access Pushpins

    HI,

    I have an Access Service report file that I have imported into MapPoint. One of the fields contains date information. We would like to perform a query for a particular date range and have those specific pushpins show up in MapPoint. How can we do this? I have never tried using Visual Basic or any other programming instructions.

    Thanks.

    John

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,084
    Blog Entries
    4
    Do you use Access much? The simplest would probably be to do your query in Access and then import the results.

    Of the ways to tackle this programmatically, I would probably recommend doing it all in Access, i.e. control MapPoint from Access VBA rather than as a MapPoint COM Add-in. I think that will give you more flexibility as far as preparing your data before it gets to MapPoint.

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

  3. #3
    bigRahn is offline Member Yellow Belt
    Join Date
    Oct 2002
    Posts
    46

    How did you import?

    I think Eric has the right idea. Do a query for reduce your dataset, then put the pushpins into MapPoint.

    But, based on your original post, one question I have is how did you import your data into MapPoint? Did the date make it into your pushpin information?

  4. #4
    surferj is offline Junior Member White Belt
    Join Date
    Apr 2003
    Posts
    5
    I found that Map Point is unable to retrieve data from a parameter querry in Access (it won't even show up in the import data wizard). I worked around this by creating a tmp table, filled it with the querry results and then pass the data through to MP.

  5. #5
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I am having the same problem; not being able to import a query that uses a function I developed to extract the Postal Area. Is the only known work around for this to dump the info into a temp table? Surely it being a MS Office product they would have developed for this?!?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filtering pushpins..Updating MapPoint by Microsoft Access
    By Rodde in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 11-18-2005, 04:22 AM
  2. Creating a subset of Pushpins from a set of pushpins
    By paf33 in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 08-09-2005, 04:54 AM
  3. How to access to an array of pushpins that were added ?
    By Jaba in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 01-13-2005, 06:20 AM
  4. UpdateLink / PushPins / Access DB / HELP!!!
    By SeanMcGinty in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-13-2004, 05:31 PM
  5. Adding pushpins and viewing map from access project
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-07-2003, 05:09 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 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81