SOLVED.
I had accidentally set a field as Indexed (No Duplicates) which kept the last few records from adding.
Thanks for reading my question.
firebirdxvi
Last Activity: Jul 1 '14, 01:32 AM
Joined: Jun 14 '14
Location:
-
Why might my ADODB.Recordset suddenly quit adding new records?
My ADODB.Recordset is being populated as desired for 5 records, then all subsequent records don't get added anywhere. I checked in debug and the code runs through this loop the desired 8 times, but only adds a record the first 5.
Any ideas why this is happening to me?
...Code:With doc.Tables(8) For I = 2 to .Rows.Count S.AddNew S![PN] = .Cell(I,3).Range.Text 'and more lines like this ^
-
firebirdxvi replied to Why am I getting the error in Access 2010 "Current Recordset does not support updatinin AccessHa! Whoops. I thought I'd copied over directly from another module that worked so I was falsely confident that wasn't the problem.
Of course I see it now and it works. Thanks for answering my question, I'm really new to this VBA stuff.Leave a comment:
-
firebirdxvi started a topic Why am I getting the error in Access 2010 "Current Recordset does not support updatinin AccessWhy am I getting the error in Access 2010 "Current Recordset does not support updatin
I am using Access 2010 and I am getting this error:
"Current Recordset does not support updating. There may be a limitation of the provider, or of the selected locktype."
...Code:Dim SQLstr as String Dim R as ADODB.Recordset Set R = New ADODB.Recordset SQLstr = "SELECT * FROM TABLE1;" R.OPEN SQLstr, CurrentProject.Connection, _ adOpenDynamic, adLockReadOnly R.AddNew
Last edited by Rabbit; Jun 15 '14, 01:36 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: