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 型態不符合 | 豬窩
Please let me know if you're looking for a article writer for your weblog.
You have some really good posts and I think I would be a
good asset. If you ever want to take some of the load off, I'd love to write some content for your blog in exchange for a link back to mine.
Please send me an e-mail if interested. Thank you!
Access Recordset 型態不符合 | 豬窩
Hi to every single one, it's truly a pleasant for me to visit this web page,
it contains helpful Information.
Access Recordset 型態不符合 | 豬窩
You really make it seem so easy with your presentation but I find this topic to be actually
something that I think I would never understand. It seems
too complicated and very broad for me. I'm looking forward for your next post, I
will try to get the hang of it!
Access Recordset 型態不符合 | 豬窩
Thank you for the good writeup. It in fact was a amusement account
it. Look advanced to more added agreeable from you!
By the way, how could we communicate?
Access Recordset 型態不符合 | 豬窩
Heya i am for the first time here. I found this board and I to find It
truly useful & it helped me out a lot. I'm hoping to present
something again and aid others such as you helped me.