Access Recordset 型態不符合
今天在寫 access vba 時用了 DAO 的 Recordset ,設定如下
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("資料表", dbOpenDynaset)
執行時一直顯示 型態不符合在 Set rs = db.OpenRecordset("資料表", dbOpenDynaset) 這一行
後來在網上找到將 Dim rs As Recordset 改成 Dim rs As DAO.Recordset 就可以了,好像是那一個 ActiveX 也用到 Recordset , 它搞混了
迴響
Access Recordset 型態不符合 | 豬窩
Hi there! This post couldn't be written any better! Reading through this post reminds me of my
previous room mate! He always kept chatting about this.
I will forward this article to him. Pretty sure he will have a good read.
Thanks for sharing!
Access Recordset 型態不符合 | 豬窩
Hi there, after reading this awesome paragraph i am as well glad to share my knowledge here with friends.
Access Recordset 型態不符合 | 豬窩
Hello, Neat post. There's an issue with your website in internet explorer,
could check this? IE nonetheless is the market leader
and a big component of folks will leave out your fantastic
writing due to this problem.
Access Recordset 型態不符合 | 豬窩
Superb, what a web site it is! This blog provides valuable
data to us, keep it up.
Access Recordset 型態不符合 | 豬窩
Actually when someone doesn't understand then its
up to other viewers that they will assist, so here it
occurs.