[AccessD] Turn a recordset into an actual table

[Bill Benson]

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
>