vb数据库编程实例VB数据库编程

VB数据库编程

ess数据库嘛？？有实例  代码给你

Public zf1 As Integer Private Sub cj98_Click() Dim bh Data2.RecordSource = "98年成绩" Data2.Refresh bh = Data1.Recordset.Fields("编号") Data2.Recordset.FindFirst ("编号" = bh) Call zf Label13 = zf1 End Sub

Private Sub cj99_Click() Dim bh As Integer Data2.RecordSource = "99年成绩" Data2.Refresh bh = Data1.Recordset.Fields("编号") Data2.Recordset.FindFirst ("编号" = bh) Call zf Label13 = zf1 End Sub

Private Sub Data1_Reposition() Dim bh As Integer bh = Data1.Recordset.Fields("编号") Data2.Recordset.MoveFirst Do While Data2.Recordset.EOF = False If Data2.Recordset.Fields("编号") = bh Then Exit Do Else Data2.Recordset.MoveNext End If Loop Call zf Label13 = zf1 End Sub

Private Sub Z1_Click() Dim bh Data1.DatabaseName = "C:Documents and SettingsAdministrator桌面db2.mdb" Data1.Refresh Data2.DatabaseName = "C:Documents and SettingsAdministrator桌面db2.mdb" Data2.Refresh bh = Data1.Recordset.Fields("编号") Data2.Recordset.FindFirst ("编号" = bh) Call zf Label13 = zf1 End Sub Sub zf() zf1 = Data2.Recordset.Fields("微机原理") + Data2.Recordset.Fields("OFFICE使用") + Data2.Recordset.Fields("五笔字型打字") + Data2.Recordset.Fields("VB编程") End Sub