Stupid Help example.

Post #22,438 by acagle 12/26/01 1:40:38 PM Reply	Stupid Help example. I am trying to get assistance on why I am getting a type mismatch error: Here is the code, BTW: Dim CurrentDB As Database Set CurrentDB = DBEngine.Workspaces(0).Databases(0) Dim TempRS As Recordset Set TempRS = CurrentDB.OpenRecordset("Table1") It doesn't like the last line. Works fine in Access 97. So I go the Access2k's Help system, type in "OpenRecordset", it gives me an "OpenRecordset Method" topic. . . .but no documentation comes up. Nothing comes up for the next topic, "Append method" either. Some topics actually have something, others don't. It's infuriating.
Post #22,449 by scoenye 12/26/01 4:22:17 PM Reply	DAO/ADO confusion It would seem there's a RecordSet in the ActiveX Data Objects and a RecordSet in the Data Access Objects. And they aren't compatible, of course. The suggested fix is to declare TempRS as DAO.RecordSet
Post #22,493 by acagle 12/27/01 11:52:06 AM Reply	Re: DAO/ADO confusion Argh. Although it wouldn't even compile when I didn't have the DAO Object Library referenced. Thankee much, kind sir. Ma'am. Whatever.
Post #22,467 by static 12/27/01 12:45:54 AM Reply	Now you know why I don't like VBA. :-) Microsoft got carried away with creating so many object hierarchies that the code gets hard to write. Wade. "All around me are nothing but fakes Come with me on the biggest fake of all!"
Post #22,505 by acagle 12/27/01 1:10:27 PM Reply	Bah! And now I just tried it on a different MDB and it won't work there. They must specifically try to screw up their products. No set of developers can actually be that bad.
Post #22,562 by tseliot 12/28/01 1:43:05 AM Reply	I've never had to set CurrentDB It's always referenced for me in Access 95/97. So I would rewrite your snippet as simply: `Dim TempRS As Recordset Set TempRS = CurrentDB.OpenRecordset("Table1")` If that helps. Doesn't fix Help, but hope it helps. --------------------------------- A stupid despot may constrain his slaves with iron chains; but a true politician binds them even more strongly by the chain of their own ideas;...despair and time eat away the bonds of iron and steel, but they are powerless against the habitual union of ideas, they can only tighten it still more; and on the soft fibres of the brain is founded the unshakable base of the soundest of Empires." Jacques Servan, 1767
Post #22,594 by acagle 12/28/01 11:41:40 AM Reply	I always wondered about that. I think I figured that out once, but then just kept copying the old code over so it never sunk in.

Welcome to IWETHEY!