Hi,

Do any of you guys know how to open the balloons on all pushpins at once? Where I work uses Mappoint to get a list of coordinates with a name and description from an SQL server, I don't deal with the backend stuff I'm just the one that has to double click on 60 pushpins a day, which on a slow VNC link is a bit boring.
I guess the maps been spread over a wall built from 14 50" DLP projection cubes makes up for it :)

Hope you can help

ben

Ben,

Not sure of anyway to do that without code (Visual Basic or something like that). Sounds like you would have to ask your administrator or whoever to see if they could add that function. If they are importing from data from SQL chances are they might know how to add a command button for you to toggle the balloons on and off. If thay are willing to help you but don't know how to do it, point them here....

thanks for the reply,

at least i know i'm not missing anything obvious. I have been speaking to the admin and he has no idea on how to do it. I imagine he would look into harder if he had to do it every day though ;)

I should probably start a new thread but does any one know how i would make the railway lines stand out more on the map?

ben

I have developed a code which you might be able to run and get all the ballons to pop up with the info. Let me know if you want me to send you the .exe file

Originally Posted by Ben Shaw

Hi,

Do any of you guys know how to open the balloons on all pushpins at once? Where I work uses Mappoint to get a list of coordinates with a name and description from an SQL server, I don't deal with the backend stuff I'm just the one that has to double click on 60 pushpins a day, which on a slow VNC link is a bit boring.
I guess the maps been spread over a wall built from 14 50" DLP projection cubes makes up for it :)

Hope you can help

ben

that would be sweet, send it to me. i'll let you know how i get on.

thanks
ben

I'm sure people would be intrested in seeing the code if you would not mind sharing with us...

[quote="Anonymous"]I have developed a code which you might be able to run and get all the ballons to pop up with the info. Let me know if you want me to send you the .exe file

Ok, this question seems to come up alot so here is the code to get the balloons to pop up for each pushpin on a mappoint map. In Visual Basic make sure you have a Reference to Microsoft Mappoint 9.0 Object Library (North America) I put this code in a command button as an example. Keep in mind there is no error checking here and if you were not running mappoint at all you would get an error.

Private Sub Command1_Click()
Dim objmap As MapPoint.Map
Dim objDataSet As MapPoint.DataSet
Dim objRecordset As MapPoint.Recordset

Set objmap = GetObject(, "MapPoint.Application").ActiveMap
For Each objDataSet In objmap.DataSets
Set objRecordset = objDataSet.QueryAllRecords
Do Until objRecordset.EOF
objRecordset.Pushpin.BalloonState = geoDisplayBalloon
objRecordset.MoveNext
Loop
Next

End Sub

John,

That worked a treat, thank you very much. I have had to use your code in an Access form as VB is not installed on our machines. I will pass it on to the BOFH so he can integrate it.

you the man
ben

Is there any way I can get that file?

Jerry,

I've developed a COM Addin for some of my clients that I plan to make available via a web site in the near future. In the mean time you can contact me directly if intrested. (I do charge for the software.)

For those intrested, the COM Addin allows you to select All Datasets or choose one from a pull down menu. You can then choose the balloon state (All info, Just name or None).