rs你声明为记录集没有? rs.open "select * from 表名",连接... Set MSFlexGrid1.DataSource = rs
dim rs as nwe adodb.recordset Set dat1= OpenDatabase(App.Path & "\aa.mdb") Set rs = Dat1.OpenRecordset("bb表") if rs.bof and rs.eof then msgbox "表中没有记录!!!",48,"错误" rs.close exit sub end if Set MSFlexGrid1.DataSource = rs msflexgrid1.refresh
错了: dim rs as nwe adodb.recordset 改为: dim rs as new adodb.recordset
用记录集提取数据库记录set MSHFlexGrid1.DataSource=记录集
Set Dat1 = OpenDatabase(App.Path & "\aa.mdb")
Set rs = Dat1.OpenRecordset("bb表")
Set MSFlexGrid1.DataSource = rs
可是他老是Set MSFlexGrid1.DataSource = rs这句话报错
说
实时错误‘91’
对象变量或with块变量未设置,怎么回事?
msgbox rs.recordcount
检查以下。
哪位大虾帮忙亚,救命了
rs.open "select * from 表名",连接...
Set MSFlexGrid1.DataSource = rs
Set dat1= OpenDatabase(App.Path & "\aa.mdb")
Set rs = Dat1.OpenRecordset("bb表")
if rs.bof and rs.eof then
msgbox "表中没有记录!!!",48,"错误"
rs.close
exit sub
end if
Set MSFlexGrid1.DataSource = rs
msflexgrid1.refresh
dim rs as nwe adodb.recordset
改为:
dim rs as new adodb.recordset