qhoqnose
جمعه 25 دی 1388, 16:00 عصر
سلام
اقا کسی میتونه بگه کد زیر چه مشکلی داره
[Option Compare Database
Private Sub Pention_BeforeUpdate(Cancel As Integer)
On Error GoTo err_beforupdate
If Me.Dirty Then
If Sa_no = Null Then
MsgBox("First should specify a staff name", vbMsgBoxlefe + vbOKOnly + vbExclamation, "Warning") = vbOK
Me.Undo
End If
End If
exit_beforeupdate:
Exit Sub
Err_BeforeUpdate:
MsgBox Err.Number & " " & Err.Description
Resume exit_beforeupdate
End Sub
اقا کسی میتونه بگه کد زیر چه مشکلی داره
[Option Compare Database
Private Sub Pention_BeforeUpdate(Cancel As Integer)
On Error GoTo err_beforupdate
If Me.Dirty Then
If Sa_no = Null Then
MsgBox("First should specify a staff name", vbMsgBoxlefe + vbOKOnly + vbExclamation, "Warning") = vbOK
Me.Undo
End If
End If
exit_beforeupdate:
Exit Sub
Err_BeforeUpdate:
MsgBox Err.Number & " " & Err.Description
Resume exit_beforeupdate
End Sub