1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
Private Sub EnSursi_BeforeUpdate(Cancel As Integer)
Call MajNb
End Sub
Private Sub EstSorti_BeforeUpdate(Cancel As Integer)
Call MajNb
End Sub
Private Sub EstVu_BeforeUpdate(Cancel As Integer)
Call MajNb
End Sub
Private Sub jourdebut_BeforeUpdate(Cancel As Integer)
Call MajNb
End Sub
Private Sub jourfin_BeforeUpdate(Cancel As Integer)
Call MajNb
End Sub
Sub MajNb()
Me!nb = DCount("*", "NomTable", "([jour]>=#" & Format$(Me!jourdebut, "mm/dd/yy") & "#) And ([jour]<=#" & Format$(Me!jourfin, "mm/dd/yy") & "#) And ([estvu]=" & Me!EstVu & ") And ([estsorti]=" & Me!EstSorti & ") And ([ensursi]=" & Me!EnSursi & ")")
End Sub |
Partager