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 型態不符合 | 豬窩
Hey There. I found your blog using msn. This is
a really well written article. I'll make sure to bookmark it and come back to read more of your useful information. Thanks for the post.
I'll definitely return.
Access Recordset 型態不符合 | 豬窩
You could certainly see your skills in the article you write.
The world hopes for even more passionate writers such as you who aren't afraid to say how they
believe. All the time go after your heart.
Access Recordset 型態不符合 | 豬窩
Hey there! I understand this is sort of off-topic
but I had to ask. Does operating a well-established blog like
yours take a large amount of work? I am brand new to operating a blog however I do write in my journal every
day. I'd like to start a blog so I will be able to share
my personal experience and thoughts online. Please let me
know if you have any recommendations or tips for brand new aspiring bloggers.
Thankyou!
Access Recordset 型態不符合 | 豬窩
Hey there! I realize this is kind of off-topic however I needed to ask.
Does building a well-established blog such as yours take a lot
of work? I'm completely new to operating a blog however I do write in my journal
everyday. I'd like to start a blog so I will be able to share my experience and feelings online.
Please let me know if you have any kind of ideas or tips for brand
new aspiring bloggers. Appreciate it!