Predmet:Re: Limitiranje upisa količine
Forma radne operacije
PreuzmiIzvorni kôd (Visual Basic):Option Compare Database
Option Explicit
Private Sub Form_Current()
'Written by Helen Feddema 4-Oct-2007
'Last modified 4-Oct-2007
On Error GoTo ErrorHandler
Call Rekord
Me.txtSelectedID.Value = Me.BROJ_OP
ErrorHandlerExit:
Exit Sub
ErrorHandler:
MsgBox "Error No: " & Err.Number & "; Description: " & _
Err.Description
Resume ErrorHandlerExit
End Sub
Function Rekord()
On Error Resume Next
Dim Bok As Integer
Bok = Me.Recordset.AbsolutePosition + 1
Me.Tag = Bok
End Function
forma realizacijasub
PreuzmiIzvorni kôd (Visual Basic):Option Compare Database
Option Explicit
Function KontrolaKomada() As Boolean
Dim Rs As Recordset
Dim Kom As Integer
Dim Rekord As Integer
Kom = 0
KontrolaKomada = False
Rekord = Forms![frmEvidencija]![frmRadneOperacije].Form.Tag
Set Rs = Me.RecordsetClone
Rs.MoveFirst
Do While Not Rs.EOF
Kom = Kom + Rs!komada
Rs.MoveNext
Loop
If Rekord > 1 Then
If Format$(Me.Tag) = "" Then GoTo Kraj
If Kom > Val(Me.Tag) Then
MsgBox "vaš unos mora biti manji od: " & Val(Me.Tag) + 1
Me.komada = 0
KontrolaKomada = True
End If
Else
Me.Tag = Kom
End If
Kraj:
End Function
Private Sub komada_Exit(Cancel As Integer)
Cancel = KontrolaKomada
End Sub
Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.