[AccessD] Turn a recordset into an actual table

[Bill Benson]

Jim have you tried the method indicated here?
https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2007/bb237827(v=office.12)?redirectedfrom=MSDN

On Tue, Oct 26, 2021 at 7:49 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
>
>  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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>