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 型態不符合 | 豬窩
I love your blog.. very nice colors & theme.
Did you design this website yourself or did you hire someone to
do it for you? Plz respond as I'm looking to create my own blog and
would like to find out where u got this from. thanks
Access Recordset 型態不符合 | 豬窩
Hi to every , since I am really eager of reading this webpage's post
to be updated regularly. It carries good material.
Access Recordset 型態不符合 | 豬窩
Hmm is anyone else experiencing problems with the images on this blog loading?
I'm trying to find out if its a problem on my end
or if it's the blog. Any feed-back would be greatly appreciated.
Access Recordset 型態不符合 | 豬窩
These are actually great ideas in on the topic of blogging.
You have touched some good factors here. Any way keep up wrinting.
Access Recordset 型態不符合 | 豬窩
Hi, i feel that i noticed you visited my web site thus i got here to
return the favor?.I'm attempting to to find issues to improve my website!I suppose its adequate to
make use of a few of your ideas!!