S
Secen
Is there a way I can copy an entire record from one
recordset to another without copying each individual
field? I open a recordset that has 6000+ records and 30
fields and apply a filter, I then want to copy those
filtered records into another recordset that is set to an
empty table that has the exact same structure as the
original. I have tried clone but doesn't seem to work:
While Not rstActivity.EOF
rstTrans.AddNew
Set rstTrans = rstActivity.Clone
rstTrans.Update
rstActivity.MoveNext
Wend
I get an error that says "Update without Addnew or Edit
called".
Since the tables are in the same database so I don't think
I can use PopulatePartial. Any ideas?
recordset to another without copying each individual
field? I open a recordset that has 6000+ records and 30
fields and apply a filter, I then want to copy those
filtered records into another recordset that is set to an
empty table that has the exact same structure as the
original. I have tried clone but doesn't seem to work:
While Not rstActivity.EOF
rstTrans.AddNew
Set rstTrans = rstActivity.Clone
rstTrans.Update
rstActivity.MoveNext
Wend
I get an error that says "Update without Addnew or Edit
called".
Since the tables are in the same database so I don't think
I can use PopulatePartial. Any ideas?