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

AddPushpin with more data than Loc and name possible?

This is a discussion on AddPushpin with more data than Loc and name possible? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am using Mappoint via VB 6.0 and the database driving the app is too complex to import directly into ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    AddPushpin with more data than Loc and name possible?

    I am using Mappoint via VB 6.0 and the database driving the app is too complex to import directly into MapPoint (please don't ask - too painful to explain). What I am trying to do and can't figure how is to add a pushpin with more data than just the location and name.
    I have the Lat/Lon plus a lot of information - the 'fields' varies from pushpin to pushpin. What I want to do is programmatically add pushpins one at a time and have a custom set of data appear in their balloons. Is this possible?

    If not, is there a way to 'hand build', on the fly, a record set that I could then use the MoveToPushpin method to creat these pins.

    With deadline approaching in two days, I am happy to offer flowers, chocolates or any form of currency to anyone who can help.

    Thanks in advance.

  2. #2
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    Just export your data to excel and import using the "Import Data Wizard"

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Quote Originally Posted by John Meyer
    Just export your data to excel and import using the "Import Data Wizard"
    John -
    Thanks for the suggestion but this is happening within an interactive application (ie the user is choosing a bunch of parameters, selecting on those parameters, mapping the result, choosing different ones, etc.) and we cannot count on them having Excel.

  4. #4
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    What about exporting to a comma seperated text file (or tab seperated) file?

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

    Adding extra data...

    How about just building the string you want in you're VB routine, and putting the whole thing into the pushpin NOTE property.

    something like:
    'assuming RS is your recordset from your db
    '
    Dim mpPushpin As MapPoint.Pushpin
    Dim mystring as string 'holder for custom data

    'looping through recordset stuff excluded

    mystring = "My custom Data: " & vbcrlf & _
    "Name: " & RS.Fields("NAme") & vbcrlf &
    "Number: " & RS.Fields("Number" & vbcrlf

    myPushpin.Note = MyString

  6. #6
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Touchdown!

    bigRahn - Thank you. That did the trick!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. addpushpin - need help to get started
    By BWard in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 12-19-2005, 02:15 PM
  2. addpushpin problem
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 9
    Last Post: 09-28-2004, 09:12 AM
  3. AddPushPin
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-01-2004, 10:41 AM
  4. addPushpin
    By nringdahl in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-27-2004, 09:09 AM
  5. AddPushpin
    By Monique in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 08-20-2002, 01:26 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