Private Sub DataGrid1_AfterInsert()
Dim mystr As String
mystr = "select id,xm,bm,rq,kssj,jssj from kaoqinbiao order by id desc"
DataGrid1.Refresh
End Sub
Private Sub DataGrid1_Click()
Dim mystr As String
mystr = "select id,xm,bm,rq,kssj,jssj from kaoqinbiao order by id desc"
End Sub
Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\考勤表\考勤系统.mdb;Persist Security Info=False"
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from kaoqinbiao"
Adodc1.Refresh