[AccessD] Turn a recordset into an actual table

[Rocky Smolin]

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
>