Re: Text of a RecordSource

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This might be a little more generic. I didn't test it though:

CurrentDB.QueryDefs(Me.RecordSource).sql


"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:9s_0i.2223$UU.791@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Martin wrote:
Hi,

ich have a Report with a recordsource.
the source is a query.

when call the function Me.RecordSource, i get the queryname.
is there a possibility to get the text of this query ??
And how ??


thx a lot
Martin

CurrentDB.QueryDefs("QueryName").sql

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.

Relevant Pages

  • RE: Filter without grouping
    ... to change the SQL property of a saved query. ... Part of the problem is that the criteria are optional: ... and passed it to the report as OpenArgs. ... creates the RecordSource, split it up into pieces to build the appropriate ...
    (microsoft.public.access.reports)
  • Re: Is it possible to show both "Yes" and "No" answers from a "yes/no"
    ... the report will not show the subreports. ... > subreport; delete that subform and the report will show that subreport. ... If you open this query in design view, ... >>> using QryJobs as its recordsource. ...
    (microsoft.public.access.gettingstarted)
  • Re: How to change the RowSource in a SubReport
    ... You say that you're just trying to apply query ... refers to the form that you are using for your selection criteria. ... You shouldn't have to change the recordsource at ... in the On Open event, you could always open the report in Design mode, ...
    (comp.databases.ms-access)
  • RE: Filter without grouping
    ... to change the SQL property of a saved query. ... Part of the problem is that the criteria are optional: ... and passed it to the report as OpenArgs. ... creates the RecordSource, split it up into pieces to build the appropriate ...
    (microsoft.public.access.reports)
  • Re: Control over labels printing
    ... and editing the report as well. ... open the labels report in Design view and click on the RecordSource ... a "query design grid" pane opens. ...
    (microsoft.public.access.reports)