MapForums

I am writing a vb application using mappoint and currently have it so that the user can enter an address, the map template i have created then zooms to the location on the map and adds a pushpin. I would like mappoint to then return the location of the nearest pushpin in a seperate dataset, is this possible.

I am currently using

objPushPin.Location.FindNearby(2).Item(1).Name

where objpushpin is the location the user has typed in, however this returns nearest places of interest (i.e. hotels, airports etc.) is it possible to have it locating nearest pushpins instead.

Thanks in advance for your help.

Dazzer

Look at the "QueryCircle" method. Using your new pushpin as the center you can enumerate other pushpins within the circle.

__________________
John
http://www.support-pc.com

Order MapPoint 2006 Here
https://secure.mp2kmag.com/?refer=support-PC

Thanks for your help, I did try this before but couldn't get it to work.
I put in the following line to add the query results to a recordset

objRecords = objMap.DataSets.Item("Pushpins").QueryCircle(objPu shPin.Location, 200)

Where objRecords is a recordset, objMap the active map, objPushpin the pushpin entered by the user and the dataset 'pushpins' contains the pushpins I wish to search for.

However when I try to run this I get the error 'Object variable or with block variable not set' which would seem to indicate it can't find the dataset (or that i am doing something very wrong!).

What the program is intended to be used for is to find the nearest store to our customers.

Its ok figured it out, it was my rather eratic typing that had caused a problem earlier on in the code!!!

In fact the queryCircle idea now works really well, thanks for your help.