okay, i've killed all the records of my db, and changed the behaviour to increment. (i hope i can re-import them later)
Originally posted by paulw
I hadn't even realised that you could randomize the autonumber! Can you not change that behaviour?
I checked out ADO last night and the bookmarks should not be destroyed by a refresh. Are you sure the dataset is bookmarkable?
What is the dataset SQL source? Maybe we can tweak that.
but now there is a new problem, i can't solve:
this method is called for each table. first time the method runs good, but second time the argument isn't passed!!!
Private Function addRecord(ByRef ado As Adodc, ByRef col As Collection, ByRef fields() As String, Optional spec As String) As Variant
'On Error GoTo AddErr
Dim bookmark As Variant
Dim i As Integer
For i = 0 To (UBound(fields) - 1)
.Recordset.fields(fields(i)) = col.item(fields(i))
i can direct call the method by <formname>.<adodc>.recordset.addnew but it isn't working with the passed reference. (nothing)