MapForums

Hello, I am just beginning a project that involves mappoint 2009 activex control and Access 2007. I need to display pushpins of locations on the north american map. With each of those pushpins I display, I need to display detailed information.

What is the best way to go about this? Create a recordset in access, and then loop through that recordset and place the pushpins on the map? I'll have all the address info (address line 1, city, state, zip). What is the best way to associate info, or have a click event for each pushpin? Is an html link the only way to go?

I'm not sure about the mappoint datasets that are associate with the mappoint control. Will I need to use those?

Thanks for any info.

Hi mike1174,

It took awhile for it to sink in, but I've now realized what you're asking.

[I think] what you want is the DataSet method .ImportData using the
ArrayOfFields parameter.

Please read and understand the ImportData Method under Programming Information in Help. Afterward, do a search of this forum for Importdata.

Mike Mattys

Hi, thanks for the reply. I am now using the ImportData method.

My next question is, I want to capture a click event associate when a user clicks on a pushpin.

I am putting pushpins on zip codes, so, all I need to do is capture what zip code is clicked.

Hi.

Also in the Programming section of Help - Events (of map only).
'Zip Code' will be a Field in the Recordset extracted from the DataSet that is parent to the Pushpin selected.

Mike Mattys

Hi, thanks for the reply.

Are you talking about the selection change event? Right now I am using that event to capture objPushPin.Name which contains the zip code I populated from my recordset. But, I'd rather use mappoints zip code since the user can change that name in the ballon popup.

So i tried referencing the objPushpin.Parent.Fields on the selection change event, but i get a field count of zero and didn't see zip code as a field.

If you have any code examples of how to get the zip code from an already placed pushpin on the selection changed event, that would be great.

Hi Mike,

Yes, SelectionChange
I only have long laborious code - simpler to just say

FR = omap.ObjectsFromPoint(X,Y)
For Each Itm in FR
If itm.type = geoShowByPostal1 Then
'Got it
End If
Next

(At least that's how I wrote it 5 years ago)

Mike Mattys

Hi, thanks for the code sample. What does FR represent though? What do you have FR declare as?

Thanks for the help.

Look up ObjectsFromPoint?