Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Brando32

    Declare Variant or Object?

    Casper - I am still new to this and have never written or referenced DLLs ... what I want to do is call code from Forms, Modules, and Classes generically ie ... have references to them passed as a parameter to a routine that will then use a that reference to call a routine of a pre-defined name...
  2. Brando32

    Declare Variant or Object?

    When using a pointer to point to a Form or a Class or a Module ... which is better to use .... a pointer declared as a Variant or as an Object ??? (And why?) Thanks! (I originally posted this in the wrong area - my apologies)
  3. Brando32

    Code Re-use in user-defined classes?

    What about if one of the functions declares a static var?
  4. Brando32

    Code Re-use in user-defined classes?

    Yes. (: I just didn't know if VB 6 could muster it - I mean it's not fully oop, right?
  5. Brando32

    Code Re-use in user-defined classes?

    Thanks Chiph!! That makes my design decision easy ... I keep doing the object oriented way!
  6. Brando32

    Code Re-use in user-defined classes?

    When you create a VB 6 class and then create many instantiations of this class during run-time - is the code part of the class shared among all the instantiations or is it re-created seperately each time? (I ask because I am debating whether to use this class as a base data type for say, a...
  7. Brando32

    Problem accessing folder using Scripting.FileSystemObject

    Thanks Matt and Rdrosk .... But I still wonder why "oFolder.Files.Item(i).Name" won't work? I did re-write the code as you said ... a for each loop and it does work.
  8. Brando32

    transferring data between two MSFlexGrids using For next loop

    Here is some code (without much comments) for you to see how to access cells of the flexgrid ... help it helps! Private Function LOADflxRESULTS() As Long Dim iNCol As Integer, iNRow As Integer 'Number of Col and Rows in rst Dim iC As Integer, iR As Integer 'Col and Row...
  9. Brando32

    Problem accessing folder using Scripting.FileSystemObject

    THanks for the response BiggerBrother .... The error is: Error 5: Invalid procedure call or argument And it occurs on the line: msgbox oFolder.Files.Item(i).Name Even if the upper bound of the loop is wrong, it still should have executed until that point. It won't even execute once .....
  10. Brando32

    Problem accessing folder using Scripting.FileSystemObject

    Hey VB Gurus .... this code snippet yields an error and I am baffled as to why. As I type the line "oFolder.Files.Item(i).Name" each part of it appears for you to select so I know it is valid syntactically, but it yields an error when run. I tried starting i at 1 and at 0, but still...
  11. Brando32

    Open connections only when you need them??

    I am fairly new to VB-SQL Server programming. Exactly how resource intensive is opening and closing a connection VERSUS keeping connections open longer in order to do several recordset-related tasks before closing the connection. I ask because I know in general tech-books say to minimize the...

Part and Inventory Search

Back
Top