References.Scripting.(Incomplete library)

  • Thread starter Thread starter PamelaFox
  • Start date Start date
P

PamelaFox

I'm working on a db that requires some functions from the Scripting
Library. I've checked the MS Scripting Runtime reference yet I'm having
difficulty accessing objects and methods within.

In particular I need to create a FileSystemObject, however when I type..

dim fso as Scripting.(intellisense does not list the full complement of
objects like 'FileSystemObject')

When I just type it in anyway and subsequently run it, I get a compile
error (method or data member not found).

So far I've:
-unchecked the ref, saved, closed db, reopened, rechecked ref, (still
nothing), closed db again, reopened, (still nothing)

-I checked to see if another computer(my home desktop comp) could see
the Scripting library in its entirety and it could. RIGHT UP UNTIL I
TRANSFERED THE DB IN QUESTION TO IT AND TRIED TO RUN MY CODE.
Now the desktop is blind to the scripting library too. Even if I start
from scratch with a brand new db!

Anyone know what the heck is going on here? I'd be indebted to you for
your help.


Pam


ADDITIONAL INFO:
Main computer:
HP Laptop
Win XP Home
Access 2000

Home Desktop:
Win XP Pro
Access 2002

Other non-default references:
MS DAO 3.6
ADO UNchecked
 
Yikes. As it turns out I was sporadically forgeting to use the 'New'
keyword while assigning a FileSystemObject.

(Face red...very red)
 
Back
Top