Re: Stand Alone Recordsets

I look the clone method but it simply creates a new pointer to an opened
recordset. If I close the recordset, its clone goes out too...

"Stephen Howe" wrote:

'Now I want to create a new recordset with data in the recordset 1 (rst)
'equals in the recordset 2 (rts)

You should look at the Clone method (and also the caveats using it).

Stephen Howe



.

Relevant Pages

  • Re: Error 3021 No Current Record
    ... but the Help files say that the bookmarks are compatible: ... > "Use the Clone method to create multiple, duplicate Recordset objects. ... > use the Clone method, you can share bookmarks between two or more Recordset ...
    (microsoft.public.access.formscoding)
  • Re: Error 3021 No Current Record
    ... but the Help files say that the bookmarks are compatible: ... "Use the Clone method to create multiple, duplicate Recordset objects. ... When trying to set one of the clone's bookmark to the bookmark of ...
    (microsoft.public.access.formscoding)
  • Re: Error 3021 No Current Record
    ... Use Me.RecordsetClone recordset, not Me.Recordset.Clone recordset. ... but the Help files say that the bookmarks are compatible: ... >> "Use the Clone method to create multiple, ... you can share bookmarks between two or more ...
    (microsoft.public.access.formscoding)
  • Re: Recordset question
    ... What if I want to first parse the data in the first recordset and using the ... results of that to create and populate the second? ... I forgot about using .Clone method. ...
    (microsoft.public.vb.database)
  • Re: Operation must use an updateable query
    ... think it has something to do with either having to restart IIS on an NT4 box ... "Stephen Howe" wrote: ... > been opened with the wrong LockMode and I don't see a RecordSet above. ... > Is it an SQL command with INSERT, ...
    (microsoft.public.data.ado)