Private Sub Command1_Click()
Dim i As Integer
Dim NewDyn As Recordset
Dim OpenWs As Workspace
Dim OpenDB As Database
Set OpenWs = DBengine.Workspaces(0)
Set OpenDB = OpenWs.Opendatabase(App.Path & " \ MyAccessDB.mdb")
Set NetDyn = OpenDB.Openrecordset("select * from temp", dbOpenSnapShot)
NewDyn.MoveLast
NewDyn.Movefirst
If NewDyn.RecordCount = 0 Then
MsgBox "请在数据库输入数据!", vbCritical
Exit Sub
End If
With MSChart1
.TitleText = "直方图实例"
.RowCount = NewDyn.ReordCount
For i = 1 To NewDyn.RecordCount
.Row = i
.Data = NewDyn.Fields("数据")
.Rowlabel = NewDyn.Fields("日期")
NewDyn.MoveNext
Next i
End With
NewDyn.Close
End Sub
Dim i As Integer
Dim NewDyn As Recordset
Dim OpenWs As Workspace
Dim OpenDB As Database
Set OpenWs = DBengine.Workspaces(0)
Set OpenDB = OpenWs.Opendatabase(App.Path & " \ MyAccessDB.mdb")
Set NetDyn = OpenDB.Openrecordset("select * from temp", dbOpenSnapShot)
NewDyn.MoveLast
NewDyn.Movefirst
If NewDyn.RecordCount = 0 Then
MsgBox "请在数据库输入数据!", vbCritical
Exit Sub
End If
With MSChart1
.TitleText = "直方图实例"
.RowCount = NewDyn.ReordCount
For i = 1 To NewDyn.RecordCount
.Row = i
.Data = NewDyn.Fields("数据")
.Rowlabel = NewDyn.Fields("日期")
NewDyn.MoveNext
Next i
End With
NewDyn.Close
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货