Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Object's properties and events window

    You know, when you define a varilable with the DIM statement an write AS it appears a small window showing you all types of Object you can specify for that variable you want to define.

    I delared fs AS Object
    then
    Set fs = CreateObject("scripting.filesystemobject")

    but when I type for example     thisPath= fs.
    now it should appear this small window to show all properties and events of the fs i.e fileSystem.

    What is missing in order to show this helpful small window?
    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107

    Re: Object's properties and events window

    Originally posted by hammbakka
    You know, when you define a varilable with the DIM statement an write AS it appears a small window showing you all types of Object you can specify for that variable you want to define.

    I delared fs AS Object
    then
    Set fs = CreateObject("scripting.filesystemobject")

    but when I type for example     thisPath= fs.
    now it should appear this small window to show all properties and events of the fs i.e fileSystem.

    What is missing in order to show this helpful small window?
    Thanks
    if you dim the variable with DIM fs as Scripting.FileSystemObject (requires reference "Microsoft Scripting Runtime" to be set) you'll get your window.

    Cheers
    bachatero

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    bachatero thank you for your reply, I checked the
    Micro$oft Scripting Reuntime but it still doesn't function.

    P.s I use Access 97

  4. #4
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107
    Originally posted by hammbakka
    bachatero thank you for your reply, I checked the
    Micro$oft Scripting Reuntime but it still doesn't function.

    P.s I use Access 97
    ah, don't know about Access 97 but I guess it "should" work anyway. otherwise have a look at the FileSystemObject in the Object Browser. There you'll find any method, property etc.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you, the object browser is a good idea, but as you know, this small window is more helpfull.

    Thanks

  6. #6
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107
    sure i know!

    if you use
    DIM fs as object
    Set fs = CreateObject(...

    then the FileSystemObject (FSO) Variable is created at runtime. While you are editing the System does not know that fs is intended to hold an FSO so how should it display the "window".

    if you use instead

    dim fs as Scripting.FileSystemObject

    in time when u type
    "fs." you should get the window.

    sometimes the help is not shown if you have an error within your code .. try hit debug to find out.

    cheers

  7. #7
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    bachatero,
    thank you very much, you are right, it functions now, when not creating the object at the run time

    Danke

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •