Nz = Artinya apa sih ??
apa Not Zero ??
pada ;
Dim strAddress As String
strAddress = Nz(Address)
strAddress = strAddress & IIf(strAddress = "", "", ", ") & Nz(City)
strAddress = strAddress & IIf(strAddress = "", "", ", ") & Nz(State)
strAddress = strAddress & IIf(strAddress = "", "", ", ") & Nz(Zip)
strAddress = strAddress & IIf(strAddress = "", "", ", ") &
Nz(CountryOrRegion)
If strAddress = "" Then
MsgBox "There is no address to map."
Else
Application.FollowHyperlink "
http://maps.live.com/default.aspx?where1="; & strAddress
End If
--
Harry Siswanto
Email: [email protected]
http://www.facebook.com/harry.siswanto
http://harry-siswanto.blogspot.com/
