(I´m sorry for my english)Hello. I have a problem with PushPin ...expect you can help me. Taking(Catching) the information of
a recordset I add a pushpin. When I add the second one I remove the Previous and this way successively.
All This to simulate movement ....but I dont want seen the tour. I have done this code but it is not a good code
and is very slow:
Private Sub Timer1_Timer()
If iTime > 0 Then
iLatid = rs("lat")
iLong = rs("lon")
iContPin = iContPin + 1 'para darle nombre al pushPin
objMap.AddPushpin objMap.GetLocation(iLatid, iLong), iContPin
If sw = False Then
sw = True
Else
Set objPin = objMap.FindPushpin(iContPin - 1)
objPin.Delete
End If
rs.MoveNext
' Si no sobrepasó el final del recordset ...
If rs.EOF Then
' se posiciona en el ultimo
rs.MoveLast
MsgBox " Se está en el ultimo registro ", vbInformation
iTime = 0
End If
End If
End Sub
Thank you very much in advance.
ikercio