Function Ucitaj()
On Error Resume Next
Dim Db As Database
Dim Rs As Recordset
Dim Mjesto As String, Zemlja As String
Dim X, Opis As String, Y
Set hd = Me.WebBrowser0.Document
Set Db = CurrentDb
Set Rs = Forms![frmGdjeJeProdan].RecordsetClone
Rs.MoveLast
Rs.MoveFirst
Do While Not Rs.EOF
Mjesto = Format$(Rs!Mjesto)
Zemlja = Format$(Rs!Zemlja)
If Mjesto <> "" Then
Opis = "Firma:" & Format$(Rs!Firma) _
& "
Adresa:" & Format$(Rs!Adresa) _
& "
Mjesto:" & Format$(Rs!Mjesto) _
& "
Proizvod:" & Format$(Rs!Proizvod) _
& "
Kolicina:" & Format$(Rs!SumOfIzlaz) & " kom."
hd.all("opis").Value = Opis
hd.all("address").Value = Mjesto & "," & Zemlja
hd.all("findAdrress").Click
End If
start:
X = hd.all("PlaceName").Value
If X = "True" Then
Rs.MoveNext
Else
DoEvents
GoTo start
End If
Loop
Rs.Close
Set Db = Nothing
Set hd = Nothing
Set hd = Nothing
End Function