[AccessD] Turn a recordset into an actual table

[Rocky Smolin]

> Oh, hypothetical. Ok.  Well, it seems that if the recordset can be
> created, that the datasheet would be the universal solution.  The column
> heading are taken from the field names, whatever they are. Where would the
> datasheet approach fall short in what you're trying to accomplish?
>
> r
>
> On Tue, Oct 26, 2021 at 10:01 AM Bill Benson <bensonforums at gmail.com>
> wrote:
>
>> 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.
>> > > > >
>> > > > >
>> > > > >
>>
>>