[AccessD] Turn a recordset into an actual table

[Jim Dettman]

 There is nothing like this anywhere in Access.

 When it comes to forms, for a dynamic record set, you can:

1. Have a series of un-bound controls, check the record set fields collection at the forms OnLoad, and then populate the controls as needed hiding the ones that you don't want to use.
2. Fill a temp table and point it to that.

 For combo's and list boxes, you can

1. fill them manually by row and column with a call back function
2. fill the recordsource with a value list
3. Use a temp table and point it to that.

   Unfortunately, Access doesn’t have a "put record set" command unlike other products (i.e. VFP).    It has a GetRows() function to bring stuff in, but not the corresponding Put.

Jim.

-----Original Message-----
From: AccessD On Behalf Of Bill Benson
Sent: Tuesday, October 26, 2021 1:25 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Turn a recordset into an actual table

Not so sure Rocky, what about recordsets based on queries with UDFs?

And I think CreateControl method will build the fields on the fly on the
subform.

On Tue, Oct 26, 2021 at 1:08 AM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> Well, the fields need to be defined somewhere.
>
> If you want to dynamically display any recordset, then the fields would
> have to be defined in the tables from which the recordset is created. Or
> perhaps a spreadsheet?
>
> I suppose you could set the record source of the datasheet to the recordset
> defined by a table or a query, and it would populate the datasheet just
> like opening up an Excel spreadsheet.
>
> But this ability to display any dataset seems a bit undefined.  Can you
> tell us more about the task which creates this need? What creates a
> requirement to display any recordset that could be presented?
>
> Sounds like an interesting problem.
>
> r
> On Mon, Oct 25, 2021 at 5:16 PM Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > Actually it has been so long since I programmed in Access UI now I am
> > second guessing my earlier idea - because I can’t remember whether the
> > datasheet subform would or would not need the fields it will be
> displaying
> > already defined?
> >
> > I was trying to think of a solution that could dynamically display any
> > recordset.
> >
> >
> >
> > On Mon, Oct 25, 2021 at 8:12 PM Rocky Smolin <rockysmolin2 at gmail.com>
> > wrote:
> >
> > > Assuming the parent form doesn't already have its own record source, it
> > > would seem to be simpler design.
> > >
> > > r
> > >
> > > On Mon, Oct 25, 2021 at 5:06 PM Bill Benson <bensonforums at gmail.com>
> > > wrote:
> > >
> > > > Could a datasheet subform whose recordsource is determined at runtime
> > be
> > > > just as useful, put on a parent form?
> > > >
> > > > Personally I don’t like creating and opening tables the database
> > doesn’t
> > > > require going forward.
> > > >
> > > > On Mon, Oct 18, 2021 at 12:33 PM Arthur Fuller <
> > fuller.artful at gmail.com>
> > > > wrote:
> > > >
> > > > > Thanks guys.
> > > > >
> > > > > A.
> > > > >
> > > > > On Mon, Oct 18, 2021 at 10:32 AM Rocky Smolin <
> > rockysmolin2 at gmail.com>
> > > > > wrote:
> > > > >
> > > > > > I would use a make table query that is the same as the query you
> > use
> > > to
> > > > > > open the recordset. Just don't forget to clean up after yourself
> -
> > > > delete
> > > > > > the table when done.  Alternatively you can put the recordset
> > records
> > > > > into
> > > > > > a table with an append query - again, delete all records in the
> > > target
> > > > > > table before the append to insure thatr you're only looking at
> the
> > > > > records
> > > > > > from the recordset.
> > > > > >
> > > > > > HTH
> > > > > >
> > > > > > r
> > > > > >
> > > > > > On Mon, Oct 18, 2021 at 3:49 AM Arthur Fuller <
> > > fuller.artful at gmail.com
> > > > >
> > > > > > wrote:
> > > > > >
> > > > > > > Is there a way to turn a recordset into a table? I hate not
> being
> > > > able
> > > > > to
> > > > > > > browse the RS and see what it contains.
> > > > > > >
> > > > > > > --
> > > > > > > Arthur
> > > > > > > --
> > > > > > > AccessD mailing list
> > > > > > > AccessD at databaseadvisors.com
> > > > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > > Website: http://www.databaseadvisors.com
> > > > > > >
> > > > > > --
> > > > > > AccessD mailing list
> > > > > > AccessD at databaseadvisors.com
> > > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > Website: http://www.databaseadvisors.com
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Arthur
> > > > > --
> > > > > AccessD mailing list
> > > > > AccessD at databaseadvisors.com
> > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > Website: http://www.databaseadvisors.com
> > > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com