Append array to recordset

T

Tom

I am looking for an easy way (without sql) to append then delete records from
a set like the following. Is there a way i can do this?

rs2.AddNew (rs1.fields, rs1.Getrows(1))


then remove the row i just moved.

Thanks

Tom
 
T

Tom

If i could collect multiple rows into an array (seperate rows, not next to
each other) then append to a recordset, it would be perfect!

Thanks

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

stuck in a loop 5
Data Type Conversion error 5
Run time error in VBA Code 1
Split not working correctly 2
"Object doesn't support this property or method" Error on Tree Con 0
Recordset from a recordset 3
Drop Down doesn't populate form 0
Dim rs as recordset or object? How to check if an rs is open? 39

Top