I am currently using the following code to add some data to a database:
With Form2.MSRDC1.Resultset
.AddNew
.rdoColumns("Date").Value = OldSelDate
.rdoColumns("TimeStart").Value = SSDay1.Tasks(number).BeginTime
.rdoColumns("TimeFinish").Value = SSDay1.Tasks(number).EndTime
.rdoColumns("Text").Value = SSDay1.Tasks(number).Text
.Update
End With
All the data is correct (e.g All column headers, and data to go into the database). I'm using an ODBC database but at the moment I keep getting the following error:
Run-time error '40002':
37000: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
I believe there is something quite wrong because I've tried to an INSERT INTO statement through VB before I tried this new way, and it was telling me there that there was no cursor specified on the Refresh Statement.
