اتفضل
تم استخدام هذا الكود
Private Sub أمر6_Click()
Dim Aded As Long
Dim FirDate As Date
Dim Curdate As Date
Dim Curdate1 As Date
Dim Teakid As Byte
Aded = Me.YWMA_sub.Form.Recordset.RecordCount
Me.YWMA_sub.SetFocus
Me.YWMA_sub.Form.Atarih.SetFocus
DoCmd.GoToRecord , , acFirst
FirDate = Me.YWMA_sub.Form.Atarih
For i = 0 To Aded - 1
Curdate1 = Me.YWMA_sub.Form.Atarih
If Curdate1 > FirDate Then
Curdate = Me.YWMA_sub.Form.Atarih
Teakid = 1
End If
If Curdate1 > FirDate Then
DoCmd.GoToRecord , , acNext
ElseIf Curdate1 = FirDate And Teakid = 0 Then
DoCmd.GoToRecord , , acNext
Else
MsgBox " ( " & Me.YWMA_sub.Form.Rjmfatwra & " ) " & "هناك تسلسل التاريخ خطأ في رقم الفاتورة", vbMsgBoxRtlReading, "تنبيه"
Exit Sub
End If
Next i
End Sub
فحص تسلسل التاريح.accdb