Private Sub Command8_Click()
k = MsgBox("您确认要删除名称为：" & Text2.Text & "的操作员吗？", vbYesNo + 32)
If k = 6 Then
If Text1.Text <> "00" Then
Data1.Recordset.Delete
Data1.Refresh
Call disp4
Else
MsgBox "管理员记录不能删除"
Exit Sub
End If
Else
Call disp4
End If
End Sub
Private Sub Command9_Click()
If bz1 = 111 Then
Data1.Recordset.Edit
Data1.Recordset.Fields(0) = Text1.Text
Data1.Recordset.Fields(1) = Text2.Text
Data1.Recordset.Fields(2) = Text3.Text
Data1.Recordset.Update
End If
If bz1 = 222 Then
Data1.Recordset.FindFirst "czydm=" + "'" + Text1.Text + "'"
If Data1.Recordset.NoMatch = False Then
MsgBox "操作员代码重复，请重新输入"
Exit Sub
Else
Data1.Recordset.AddNew
Data1.Recordset.Fields(0) = Text1.Text
Data1.Recordset.Fields(1) = Text2.Text
Data1.Recordset.Fields(2) = Text3.Text
Data1.Recordset.Update
End If
End If
Command1.Enabled = True
Command2.Enabled = True
Command3.Enabled = True
Command4.Enabled = True
Command5.Enabled = True
Command6.Enabled = True
Command7.Enabled = True
Command8.Enabled = True
Command9.Enabled = False
Command1.SetFocus
Data1.Refresh
End Sub
Private Sub Form_Activate()
Text1.Locked = True
Text2.Locked = True
Text3.Locked = True
Command1.SetFocus
Call disp4
Command9.Enabled = False
End Sub
Private Sub Form_Load()
Me.Top = 600
Me.Left = 1100
Data1.DatabaseName = App.Path + "\gzglxt.mdb"
Data1.RecordSource = "mmk"
Data1.Refresh
End Sub
3主界面设计:
主界面代码设计:
Private Sub bmgl_Click()
Form6.Show
End Sub
Private Sub dgzb_Click()
Dr2.Show
End Sub
Private Sub dgzt_Click()
Dr1.Show
End Sub
Private Sub dhzb_Click()
Form7.Show
End Sub
Private Sub ggdx_Click()
Form3.Show
End Sub
Private Sub gldx_Click()
Form4.Show
End Sub
Private Sub lgdx_Click()
Form2.Show
End Sub
Private Sub lrbm_Click()
Form1.Show
End Sub
Private Sub MDIForm_Activate()
sb1.Panels(2).Text = "操作员：" + czy
If bz > 0 And bz <> 0 Then
&n
