Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
Function Pregledi(BrPredmeta As String) Dim SQL As String Dim Db As DAO.Database Dim Rs As DAO.Recordset Dim Temp As String, Znak As String Dim BrRekorda As Integer, I As Integer SQL = "SELECT Prezime, Ime,Broj_Predmeta_Pregleda " _ & "FROM tblINSPEKTORI " _ & "INNER JOIN tblINSPEKTORI_NA_PREGLEDU ON tblINSPEKTORI.JMBG_Inspektor = " _ & "tblINSPEKTORI_NA_PREGLEDU.JMBG_Inspektor " _ & "WHERE Broj_Predmeta_Pregleda= '" & BrPredmeta & "'" Set Db = CurrentDb Set Rs = Db.OpenRecordset(SQL) If Rs.RecordCount = 0 Then MsgBox "Nema Podataka" GoTo Kraj: End If Do While Not Rs.EOF Temp = Temp & Rs!Ime & " " & Rs!Prezime & " isprava broj " & Rs!Broj_Predmeta_Pregleda & ", " Rs.MoveNext Loop Temp = Left(Temp, Len(Temp) - 3) BrRekorda = Rs.RecordCount If BrRekorda > 1 Then For I = 1 To Len(Temp) - 1 Znak = Mid(Temp, Len(Temp) - I, 1) If Znak = "," Then Mid(Temp, Len(Tem