Need to modify my VB code so that I can edit records instead of adding them.
Posted on 2002-04-29
I have the following code in VB, which allows me to go through a collection of NotesDocuments and add rows
to a table in access.
What I want to do is modify the AddNew so that I can edit the row if it already exists in Access. I
tried using seek but couldnt achieve it. Pls help.
For x = 1 To intNotesDocCount
Set doc = dc.GETNTHDOCUMENT(x)
On Error Resume Next
For Each fld In .Fields
varGetItem = doc.GETITEMVALUE(fld.Name)(0)
fld.Value = CStr(varGetItem)