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 ????? | ??
Access Recordset 型態不符合 | 豬窩
Hi there, for all time i used to check webpage
posts here early in the dawn, since i enjoy to gain knowledge of more and more.
Access Recordset 型態不符合 | 豬窩
Excellent website. A lot of helpful info here.
I'm sending it to a few friends ans also sharing in delicious.
And naturally, thanks for your effort!
Access Recordset 型態不符合 | 豬窩
Cbd oil that works 2020
Undeniably believe that which you stated. Your favorite justification appeared to be on the web the easiest thing to be aware of.
I say to you, I certainly get irked while people consider worries that they plainly don't know
about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people
could take a signal. Will likely be back to get more.
Thanks best cbd oil for pain http://tinyurl.com/cbd-oil-that-works-2020 cbd oil that works 2020
http://tinyurl.com/cbd-oil-that-works-2020
Access Recordset 型態不符合 | 豬窩
I am curious to find out what blog system you happen to be working with?
I'm having some minor security problems with my latest blog
and I'd like to find something more secure. Do you have any recommendations?