Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
Dim strSQL As String Dim rs As DAO.Recordset strSQL = "KORISNIK" strSQL=" SELECT * from Qzaperiod1 WHERE datum BETWEEN DATEVALUE('" & pocetni & "') AND DATEVALUE('" & krajnji & "') " Set rs = CurrentDb.OpenRecordset(strSQL) WITH rs IF NOT .BOF AND NOT .EOF Then 'provjerimo dali uopce ima podataka u bazi 'dobro je pomaknuti se na kraj baze pa onda opet na pocetak 'nije neophodno ali ponekad zna pomoci .MoveLast .MoveFirst WHILE (Not .EOF) 'WHILE LOOP petlja u kojoj kada dodemo do kraja baze (EOF)izlazimo iz petlje Debug.Print rs.Fields("imeKolone1") & " " & rs.Fields("imeKolone2") ' mozes podatke umjesto u msgbox ispisivati u debug (immediate window) .Mov