[AccessD] Turn a recordset into an actual table

[Rocky Smolin]

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
>