[AccessD] Turn a recordset into an actual table

[Arthur Fuller]

Thank

On Wed, Oct 27, 2021 at 10:05 AM Bill Benson <bensonforums at gmail.com> wrote:

> Which property gives you the SQL may depend on the type of recordset (DAO
> or ADO). If DAO, I think it is the name property of the recordset
>
> On Wed, Oct 27, 2021 at 9:04 AM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > Thanks, Stuart
> > What would be the equivalent to display the SQL for a named Record Set
> > rather than a QueryDef?
> >
> > On Tue, Oct 26, 2021 at 5:58 PM Stuart McLachlan <stuart at lexacorp.com.pg
> >
> > wrote:
> >
> > > On 26 Oct 2021 at 11:22, Arthur Fuller wrote:
> > >
> > > > The code depends on the existence of a named RecordSet....
> > > >  button that builds a SQL In() clause
> > > > from the selected Machine IDs. I plug the resultant In() clause into
> a
> > > > queryDef. But I want to be able to browse the result as if it were an
> > > > actual table....
> > > >To begin with, I need a tool that, given the name of a QueryDef, shows
> > me
> > > the SQL.
> > >
> > >
> > > You appear to be conflating the concepts of Recordset and QueryDef.
> > >
> > > If you have a QueryDef, you can open it in the QBE grid with
> > > Docmd.Openquery.
> > > You can get it's SQL by using th QueryDef object's SQL property
> > >
> > > Function ShowQuery() As Long
> > > Dim strQName As String
> > > Dim qd As QueryDef
> > > strQName = "qryMyQuery"
> > > Set qd = CurrentDb.QueryDefs(strQName)
> > > MsgBox qd.Name
> > > MsgBox qd.SQL
> > > DoCmd.OpenQuery strQName
> > > End Function
> > >
> > >
> > > --
> > > 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
>


-- 
Arthur