VB工资管理系统(四)

最新活动：微信集50个赞就可获取任意一篇钻石会员文档。详情见微信集赞换文档

VB工资管理系统(四)
        Unload Me
        gzglxt.Show
Else
     MsgBox "密码不符，请核对后再输入"
     Text3.Text = ""
     Text3.SetFocus
End If
End Sub

Private Sub Command2_Click()
End
End Sub

Private Sub Form_Load()
Data1.DatabaseName = App.Path + "\gzglxt.mdb"
Data1.RecordSource = "mmk"
Data1.Refresh
End Sub

Private Sub Text1_Change()
If Len(Text1.Text) >= 2 Then
     Data1.Recordset.FindFirst "czydm=" + "'" + Text1.Text + "'"
     If Data1.Recordset.NoMatch = True Then
        MsgBox "操作员代码不存在，请核对后再输入!"
        Text1.Text = ""
        Text1.SetFocus
     Else
        Text2.Text = Data1.Recordset.Fields(1)
        Text3.SetFocus
     End If
End If
End Sub

Private Sub Text3_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Command1.SetFocus
End If
End Sub

2.数据恢复界面:

数据恢复代码设计:
Private Sub Command1_Click()
Data1.Recordset.MoveFirst
Call disp4
End Sub
Sub disp4()
   Text1.Text = Data1.Recordset.Fields(0)
   Text2.Text = Data1.Recordset.Fields(1)
   Text3.Text = Data1.Recordset.Fields(2)
End Sub

Private Sub Command10_Click()
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
Call disp4
End Sub

Private Sub Command2_Click()
   If Data1.Recordset.BOF = False Then Data1.Recordset.MovePrevious
   If Data1.Recordset.BOF = True Then Data1.Recordset.MoveNext
   Call disp4
End Sub

Private Sub Command3_Click()
If Data1.Recordset.EOF = False Then Data1.Recordset.MoveNext
If Data1.Recordset.EOF = True Then Data1.Recordset.MovePrevious
Call disp4
End Sub

Private Sub Command4_Click()
Data1.Recordset.MoveLast
Call disp4
End Sub

Private Sub Command5_Click()
dm = InputBox("请输入您要查找的操作员的代码")
Data1.Recordset.FindFirst "czydm=" + "'" + dm + "'"
If Data1.Recordset.NoMatch = True Then
     MsgBox "查无此操作员"
     Exit Sub
Else
     Call disp4
End If
End Sub

Private Sub Command6_Click()
Command1.Enabled = False
Command2.Enabled = False
Command3.Enabled = False
Command4.Enabled = False
Command5.Enabled = False
Command6.Enabled = False
Command7.Enabled = False
Command8.Enabled = False
Command9.Enabled = True
Command10.Enabled = True
Text1.Locked = False
Text2.Locked = False
Text3.Locked = False
Text1.SetFocus
bz1 = 111
End Sub

Private Sub Command7_Click()
Comman

首页上一页 1 2 3 4 5 6 下一页尾页 4/6/6

VB工资管理系统(四)由毕业论文网（www.huoyuandh.com）会员上传。