[AccessD] Turn a recordset into an actual table

[Bill Benson]

Not sure what you are asking. I wrote with a hypothetical app in mind. If I
needed to see the results of a recordset (based on a query) I could create
that with any kind of query access allows except action queries.

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

> Bill:
>
> Where does the data come from that your app is supposed to display?
>
> r
>
> On Mon, Oct 25, 2021 at 10:25 PM Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > 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
>