Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

printing - query list

Discussion in 'Information Technology' started by Lou Sanderson, Jul 28, 2006.

  1. Lou Sanderson

    Lou Sanderson
    Expand Collapse
    Guest

    Access 2003
    Windows XP

    I would like to print the names of all the queries I have in my Access
    database. Right now the only way I can think to do this is via a screen
    capture.

    Anyone know of another way I can print out a list of all the queries I have
    in my database?
     
  2. Loading...

    Similar Threads Forum Date
    Controversial War over Private Printing of "Birs" Intensifies Hard Talk Jul 9, 2011
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 26 Jul 2006 10:58:02 -0700, Lou Sanderson wrote:

    > Access 2003
    > Windows XP
    >
    > I would like to print the names of all the queries I have in my Access
    > database. Right now the only way I can think to do this is via a screen
    > capture.
    >
    > Anyone know of another way I can print out a list of all the queries I have
    > in my database?


    Just the Name of the query?
    Create a new report.
    As Report Record Source write:
    SELECT MSysObjects.Name FROM MSysObjects WHERE
    (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
    MSysObjects.Name;

    Add the Name field to the report detail section.
    Run the report.

    Did you check out the built-in Access Documenter?
    Tools + Analyze + Documenter
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Lou Sanderson

    Lou Sanderson
    Expand Collapse
    Guest

    Fred,

    Yes, just the Name of the query.

    I had a little trouble following your instructions:

    1) Create new report
    - Check

    2) As Report Record Source write...
    - I am not familiar with reports, how do I add a Report Record Source?

    Thanks,
    Lou

    "fredg" wrote:

    > On Wed, 26 Jul 2006 10:58:02 -0700, Lou Sanderson wrote:
    >
    > > Access 2003
    > > Windows XP
    > >
    > > I would like to print the names of all the queries I have in my Access
    > > database. Right now the only way I can think to do this is via a screen
    > > capture.
    > >
    > > Anyone know of another way I can print out a list of all the queries I have
    > > in my database?

    >
    > Just the Name of the query?
    > Create a new report.
    > As Report Record Source write:
    > SELECT MSysObjects.Name FROM MSysObjects WHERE
    > (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
    > MSysObjects.Name;
    >
    > Add the Name field to the report detail section.
    > Run the report.
    >
    > Did you check out the built-in Access Documenter?
    > Tools + Analyze + Documenter
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     
  5. fredg

    fredg
    Expand Collapse
    Guest

    On Wed, 26 Jul 2006 12:18:02 -0700, Lou Sanderson wrote:

    > Fred,
    >
    > Yes, just the Name of the query.
    >
    > I had a little trouble following your instructions:
    >
    > 1) Create new report
    > - Check
    >
    > 2) As Report Record Source write...
    > - I am not familiar with reports, how do I add a Report Record Source?
    >
    > Thanks,
    > Lou
    >
    > "fredg" wrote:
    >
    >> On Wed, 26 Jul 2006 10:58:02 -0700, Lou Sanderson wrote:
    >>
    >>> Access 2003
    >>> Windows XP
    >>>
    >>> I would like to print the names of all the queries I have in my Access
    >>> database. Right now the only way I can think to do this is via a screen
    >>> capture.
    >>>
    >>> Anyone know of another way I can print out a list of all the queries I have
    >>> in my database?

    >>
    >> Just the Name of the query?
    >> Create a new report.
    >> As Report Record Source write:
    >> SELECT MSysObjects.Name FROM MSysObjects WHERE
    >> (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
    >> MSysObjects.Name;
    >>
    >> Add the Name field to the report detail section.
    >> Run the report.
    >>
    >> Did you check out the built-in Access Documenter?
    >> Tools + Analyze + Documenter
    >> --
    >> Fred
    >> Please respond only to this newsgroup.
    >> I do not reply to personal e-mail
    >>


    On the main database folder, select Reports.
    Click on New.
    A dialog box will open. Select Design View.
    Do NOT enter anything in the Choose the table or query box.

    Click OK

    When the report in design view opens, right-click on the little square
    where the upper and left side ruler's meet (or click View + Properties
    from the Menu tool bar).
    Select Properties.
    Click on the Data tab.
    The first line is the report's record source line.
    Directly on that line write (all on one line):

    SELECT MSysObjects.Name FROM MSysObjects WHERE
    (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
    MSysObjects.Name;

    Close the properties box.

    Then click on the field list tool button (it looks like a piece of
    paper with writing on it).
    Select and then drag the Name field onto the report detail section.
    You can delete the label that is attached to the text control.
    Save and run the report.

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  6. Lou Sanderson

    Lou Sanderson
    Expand Collapse
    Guest

    Fred,
    Mission accomplished. Thank you
    -Lou

    "fredg" wrote:

    > On Wed, 26 Jul 2006 12:18:02 -0700, Lou Sanderson wrote:
    >
    > > Fred,
    > >
    > > Yes, just the Name of the query.
    > >
    > > I had a little trouble following your instructions:
    > >
    > > 1) Create new report
    > > - Check
    > >
    > > 2) As Report Record Source write...
    > > - I am not familiar with reports, how do I add a Report Record Source?
    > >
    > > Thanks,
    > > Lou
    > >
    > > "fredg" wrote:
    > >
    > >> On Wed, 26 Jul 2006 10:58:02 -0700, Lou Sanderson wrote:
    > >>
    > >>> Access 2003
    > >>> Windows XP
    > >>>
    > >>> I would like to print the names of all the queries I have in my Access
    > >>> database. Right now the only way I can think to do this is via a screen
    > >>> capture.
    > >>>
    > >>> Anyone know of another way I can print out a list of all the queries I have
    > >>> in my database?
    > >>
    > >> Just the Name of the query?
    > >> Create a new report.
    > >> As Report Record Source write:
    > >> SELECT MSysObjects.Name FROM MSysObjects WHERE
    > >> (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
    > >> MSysObjects.Name;
    > >>
    > >> Add the Name field to the report detail section.
    > >> Run the report.
    > >>
    > >> Did you check out the built-in Access Documenter?
    > >> Tools + Analyze + Documenter
    > >> --
    > >> Fred
    > >> Please respond only to this newsgroup.
    > >> I do not reply to personal e-mail
    > >>

    >
    > On the main database folder, select Reports.
    > Click on New.
    > A dialog box will open. Select Design View.
    > Do NOT enter anything in the Choose the table or query box.
    >
    > Click OK
    >
    > When the report in design view opens, right-click on the little square
    > where the upper and left side ruler's meet (or click View + Properties
    > from the Menu tool bar).
    > Select Properties.
    > Click on the Data tab.
    > The first line is the report's record source line.
    > Directly on that line write (all on one line):
    >
    > SELECT MSysObjects.Name FROM MSysObjects WHERE
    > (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
    > MSysObjects.Name;
    >
    > Close the properties box.
    >
    > Then click on the field list tool button (it looks like a piece of
    > paper with writing on it).
    > Select and then drag the Name field onto the report detail section.
    > You can delete the label that is attached to the text control.
    > Save and run the report.
    >
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     

Share This Page