Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
Private Sub proizvod_BeforeUpdate(Cancel As Integer)
Dim rstproizvod As Recordset, strproizvod As String
Dim SQL As String
SQL = "SELECT COUNT(*) AS broj FROM tblproizvodi WHERE proizvod = '" & strproizvod & "'"
Set rs = CurrentDb.OpenRecordset(SQL, dbOpenSnapshot)
Dim broj_redova As Integer
broj_redova = rs!broj
If brojRedova > 0 Then
'MsgBox "Postoji " & brojRedova & " red(ova)."
'ako sta trebas jos raditi
Else
answer = MsgBox("Nemate artikl sa tom sifrom!!!Zelite li unijeti?", vbQuestion + vbYesNo, DLookup("KORISNIK", "tblKorisnik"))
If answer = vbYes Then
DoCmd.OpenForm "frmPROIZVODI", acNormal, , , , acDial