7,763
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Private cn As New ADODB.Connection
Private rs As New ADODB.Recordset
Private cnStr As String
Private Sub Form_Load()
Dim sql As String
sql = "Select * from [doc]"
getDate (sql)
showData
End Sub
Private Function getDate(cnStr)
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "PROVIDER=microsoft.jet.oledb.4.0;persist security info =false;data source=" & App.Path & "\data\data.mdb" & ";Jet OLEDB:Database"
Set rs = New ADODB.Recordset
rs.Open cnStr, cn, 1, 3
End Function
Private Function showData()
With MSHFlexGrid1
.Clear
.Cols = 6
.ColWidth(0) = 0
.ColWidth(1) = 1400.ColWidth(2) = 4670
.ColWidth(3) = 1200
.ColWidth(4) = 1800
.ColWidth(5) = 1200
.ColAlignmentFixed = flexAlignCenterCenter
.Recordset = rs
End With
End Function