Re: Recordset in Memory

Tech-Archive recommends: Fix windows errors by optimizing your registry

I just realized I did not fully explain my problem (sorry). I need to create
a multi-record recordset where the recordset's fields are calculated from
code, then I need to create other recordsets which need to loop through the
initial recordset's records.

I'm currently saving the initial recordsets records to a temporary table and
then accessing that table with the other recordsets. My question is can I do
all this (in memory) without having to save the initial recordset to a table.

Sorry for the confusion.

Thanks,

Michael

"Brian Stoll via AccessMonster.com" wrote:

> For Ex:
>
> Private Sub someThing_someFunction()
> Dim dbs As DAO.Database
> Dim rstRecord As DAO.Recordset
>
> CODE CODE CODE CODE CODE CODE
>
> Exit_someThing_someFunction:
> Set dbs = Nothing
> rstRecord.Close
> Exit Sub ' Or "Resume Next" if it's right before the "End Sub"
> End Sub
>
> --
> Message posted via http://www.accessmonster.com
>
.

Relevant Pages

  • Re: Recordset in Memory
    ... then I need to create other recordsets which need to loop through the ... >> Private Sub someThing_someFunction ... >> Dim dbs As DAO.Database ... >> CODE CODE CODE CODE CODE CODE ...
    (microsoft.public.access.modulesdaovba)
  • Re: refresh not working
    ... Recordset type variable named Rec (which is presumably declared somewhere ... Since you are demonstrating recordsets, ... > Private Sub Form_Open ... > Call OpenRecSet ...
    (comp.databases.ms-access)
  • RE: Error 2455 on close of db
    ... Private Sub TogEdit_AfterUpdate ... Dim strCaption As String ... objects, recordsets, etc.)? ... and I'm getting Error 2455 when I close the database from this form. ...
    (microsoft.public.access.formscoding)
  • Unable to delete row
    ... I'm new to VB.net and am used to working with recordsets (much ... I have a datagrid that, when the user double clicks on a row, ... None of the incredibly overpriced books I have seem to be of any help. ... Private Sub dgProjItems_DoubleClick(ByVal sender As Object, ...
    (microsoft.public.dotnet.languages.vb)
  • Too few parameters
    ... I am experimenting with recordsets. ... Dim dbs As Database, rst As Recordset ... Set dbs = CurrentDb ... Set rst = dbs.OpenRecordset ...
    (microsoft.public.access.formscoding)