使用ADODC控件, 配置好ODBC连接方式, RecordSource选择数据库中的唯一一个表.
在Form_Load中测了一句"a = Adodc1.Recordset.RecordCount"就报错:
"Object varialbe or With block variable not set"Private Sub Form_Load()
a = Adodc1.Recordset.RecordCount
End Sub
求各位大侠解救,谢谢!
在Form_Load中测了一句"a = Adodc1.Recordset.RecordCount"就报错:
"Object varialbe or With block variable not set"Private Sub Form_Load()
a = Adodc1.Recordset.RecordCount
End Sub
求各位大侠解救,谢谢!
然后
Private Sub Form_Load()
Adodc1.Refresh
a = Adodc1.Recordset.RecordCount
msgbox a
End Sub
1.connectionstring属性
2.recordsource属性(制定你所要对应的那个数据表中那几条记录)
然后:
Private Sub Form_Load()
dim a as integer
Adodc1.Refresh
a = Adodc1.Recordset.RecordCount
debug.print cstr(a)
End Sub