User Profile

vacuit · Sep 10 '07, 07:02 PM

Can you see where I am going wrong?

Code:

 'SAVE THE RESULTS TO THE DATABASE  

       Dim c_strAccessMDBFile As String = CStr(IBM.txtdblocation.Text) & "CrustaceanIBM.mdb"
        
       Dim myConn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & c_strAccessMDBFile & ";")
        Dim myDataAdapter As New OleDb.OleDbDataAdapter()

...

vacuit · Aug 15 '07, 03:14 PM

I am getting the Error: Object reference not set to an instance of an object. for this code:

Class udtYear
Public N As Long 'total population size
...
End Class

Class udtRun
Public Yr(0 To PROJYR - MINYR) As udtYear 'year -1 of model simulation
End Class

Sub CrustaceanIBM()
...
...

vacuit · Aug 14 '07, 05:26 PM

Visual Basic 2005
I want to save a copy of a datatable (that the user has changed) with a new name back to the database (Access)

I have this code to save a copy with a new name to the dataset...how do I then update the database (without changing the original datatable)? Essentially I want to add a new datatable to the database.

Dim dt As New DataTable
dt = MyDataSet.Origi nalDataTable.Co py
dt.TableName...

User Profile

Profile Sidebar

getting INSERT INTO syntax error for this code

creating vs. defining an array

Saving a new datatable to an Access Database (Visual Basic 2005)