Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    24

    Unanswered: Print List of Queries

    Is there a way to print out a list of the existing queries in a database. I have over 200 queries and it would make it easier to have a reference.

  2. #2
    Join Date
    Oct 2002
    Location
    Greensboro, NC
    Posts
    50

    Post

    HI,

    Try using the Documenter, which is found under Tools -Analyze - Documenter. Select Queries then select all - OK.

    This will give you the Query name, properties,SQL,Any Parameters and columns.

    tjacobs

  3. #3
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    If you only want the names of the queries, just put this code in the RecordSource of the textbox in the report.

    SELECT [Name] FROM MsysObjects
    WHERE (([Type] = 5) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*"))
    ORDER BY [Name];

    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •