Compilation of VBA code - Help

Compilation of VBA code - Help

Post by Noreen Bole » Thu, 02 Oct 1997 04:00:00



Please someone help - I can't get the AddObjectByName line to compile!!!

    Dim rstTable as SQLOLE.table

       oTransfer.CopyAllTables = False
         For Each rstTable In
gobjSQLServer1.Databases(strSourceDBname).Tables
           If StrComp(rstTable.Name, "equip_tbl") <> 0 And _
            StrComp(rstTable.Name, "parameter_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "dod_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "non_dod_class_tbl") <> 0 Then
               ' place in transfer object
              oTransfer.AddObjectByName(rstTable.Name, SQLOLEObj_UserTable)
              Debug.Print rstTable.Name
           End If
         Next rstTable

 
 
 

1. Compilation in VBA code using DMO objects - Help

Please someone help - I can't get the AddObjectByName line to compile!!!

    Dim rstTable as SQLOLE.table

       oTransfer.CopyAllTables = False
         For Each rstTable In
gobjSQLServer1.Databases(strSourceDBname).Tables
           If StrComp(rstTable.Name, "equip_tbl") <> 0 And _
            StrComp(rstTable.Name, "parameter_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "dod_class_tbl") <> 0 And _
            StrComp(rstTable.Name, "non_dod_class_tbl") <> 0 Then
               ' place in transfer object
              oTransfer.AddObjectByName(rstTable.Name, SQLOLEObj_UserTable)
              Debug.Print rstTable.Name
           End If
         Next rstTable

2. Create ODBC DNS in VB6 Help

3. VB code vs VBA code

4. A Stored Procedure that must be runnig for all day long everyday.

5. System ODBC parameter in VBA code gives 3423 run-time error code

6. VBA Code vs. VBScript Code

7. Help: Query ran from VBA code return incorrect results

8. Please Help re Code OK in VBA, not in VB re Workgroup Information File

9. VB Code run differently based on Compilation

10. Calling VBA code in MS Access 2000 in VB6

11. VBA view code