0,
Dim WithEvents CurrRDS As ADODB.Recordset1,这样定义数据库:
Set CurrRDS = New ADODB.Recordset2,这样打开的数据库:
CurrRDS.Open "样表", "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & CurrDBM, adOpenDynamic, adLockOptimistic3,没法排序操作:
CurrRDS.Sort = "成绩 DESC"4,请指点!
Dim WithEvents CurrRDS As ADODB.Recordset1,这样定义数据库:
Set CurrRDS = New ADODB.Recordset2,这样打开的数据库:
CurrRDS.Open "样表", "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & CurrDBM, adOpenDynamic, adLockOptimistic3,没法排序操作:
CurrRDS.Sort = "成绩 DESC"4,请指点!
Dim WithEvents CurrRDS As ADODB.Recordset
Dim CurrDBM As StringSet CurrCNN = New ADODB.Connection
Set CurrRDS = New ADODB.RecordsetIf CurrDBM = "" Then CurrDBM = Get_FName(Me, "Open", "*.mdb")'自定义函数,打开Open对话框
If CurrDBM <> "" And CurrRDS.Source = "" Then
CurrRDS.CursorLocation = adUseClient
CurrCNN.Provider = "Microsoft.Jet.OLEDB.4.0"
CurrCNN.ConnectionString = "Data Source=" & CurrDBM 'CurrDBM=数据库全路径文件名
CurrCNN.Open
CurrRDS.Open "SELECT * FROM 表名", CurrCNN, adOpenDynamic, adLockOptimistic, adCmdText
CurrRDS.Sort = "字段名 ASC"
End If