IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / I've never had to set CurrentDB
Post #22,562
by tseliot
Picture of tseliot
12/28/01 1:43:05 AM
Reply
New 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
New 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.
     What's different between M$ Access 97 and Access 2000? - (CRConrad) - (14) - Dec. 20, 2001, 04:58:37 PM EST
         Create this clutter... - (ChrisR) - (11) - Dec. 20, 2001, 05:07:09 PM EST
             Aha, thanks. Anything more? Anyone else? Cagle...? -NT - (CRConrad) - (9) - Dec. 20, 2001, 06:13:59 PM EST
                 The difference - (nking) - Dec. 20, 2001, 06:29:05 PM EST
                 Erk. Here I am. - (acagle) - (7) - Dec. 24, 2001, 11:54:31 AM EST
                     Stupid Help example. - (acagle) - (6) - Dec. 26, 2001, 01:40:38 PM EST
                         DAO/ADO confusion - (scoenye) - (1) - Dec. 26, 2001, 04:22:17 PM EST
                             Re: DAO/ADO confusion - (acagle) - Dec. 27, 2001, 11:52:06 AM EST
                         Now you know why I don't like VBA. :-) - (static) - (1) - Dec. 27, 2001, 12:45:54 AM EST
                             Bah! - (acagle) - Dec. 27, 2001, 01:10:27 PM EST
                         I've never had to set CurrentDB - (tseliot) - (1) - Dec. 28, 2001, 01:43:05 AM EST
                             I always wondered about that. - (acagle) - Dec. 28, 2001, 11:41:40 AM EST
             Re: Create this clutter... - (altmann) - Dec. 20, 2001, 08:13:48 PM EST
         Here's a few quick differences - (rickw) - (1) - Dec. 24, 2001, 07:19:46 PM EST
             Re: form f is created and bound to v. - (mmoffitt) - Jan. 3, 2002, 02:53:01 PM EST

Truly, you have a dizzying intellect.
41 ms