7,714
社区成员
发帖
与我相关
我的任务
分享
Public Sub 写保护开关(kg As Boolean)
On Error GoTo 写保护开关_Err
If (kg = True) Then
Forms![信息录入].明细录入.Locked = True
Forms![信息录入].AllowAdditions = False
Forms![信息录入].AllowDeletions = False
Forms![信息录入].AllowEdits = False
'MsgBox "写保护开 ", , "警告"
ElseIf (kg = False) Then
Forms![信息录入].AllowAdditions = True
Forms![信息录入].AllowDeletions = True
Forms![信息录入].AllowEdits = True
Forms![信息录入].明细录入.Locked = False
Forms![信息录入].写保护.Value = True
'MsgBox "写保护关 ", , "警告"
End If
写保护开关_Exit:
Exit Sub
写保护开关_Err:
MsgBox Error$
Resume 写保护开关_Exit
End Sub
For Each ctl In Me.Controls
If ctl.Name <> "Check8" And ctl.ControlType <> acLabel Then
If Me.Check8 = True Then
ctl.Locked = True
Else
ctl.Locked = False
End If
End If
Next
End Sub
Private Sub 单号选择_GotFocus()
写保护开关 False
End Sub
Private Sub 单号选择_LostFocus()
写保护开关 True
End Sub
Private Sub Form_Open(Cancel As Integer)
写保护开关 True
End Sub
Private Sub 下一条_Click()
On Error GoTo Err_下一条_Click
DoCmd.GoToRecord , , acNext
写保护开关 Forms![信息录入].写保护.Value
Exit_下一条_Click:
Exit Sub
Err_下一条_Click:
MsgBox Err.Description
Resume Exit_下一条_Click
End Sub
Private Sub 上一条_Click()
On Error GoTo Err_上一条_Click
DoCmd.GoToRecord , , acPrevious
写保护开关 Forms![信息录入].写保护.Value
Exit_上一条_Click:
Exit Sub
Err_上一条_Click:
MsgBox Err.Description
Resume Exit_上一条_Click
End Sub
Private Sub 首记录_Click()
On Error GoTo Err_首记录_Click
DoCmd.GoToRecord , , acFirst
Exit_首记录_Click:
Exit Sub
Err_首记录_Click:
MsgBox Err.Description
Resume Exit_首记录_Click
End Sub
Private Sub 尾记录_Click()
On Error GoTo Err_尾记录_Click
DoCmd.GoToRecord , , acLast
Exit_尾记录_Click:
Exit Sub
Err_尾记录_Click:
MsgBox Err.Description
Resume Exit_尾记录_Click
End Sub
Private Sub 添加记录_Click()
On Error GoTo Err_添加记录_Click
写保护_btn_Click
DoCmd.GoToRecord , , acNewRec
Exit_添加记录_Click:
Exit Sub
Err_添加记录_Click:
MsgBox Err.Description
Resume Exit_添加记录_Click
End Sub
写保护开关 Forms![信息录入].写保护.Value