Database Documentation - List of Queries

[Guest]

I am trying to get a list of all my queries so that I can create training
documentation without having to retype all the query names...is there a way
to do this (other than screen print)? I have about 40 queries.

 

[Guest]

MSMichelle,

One way is to loop through the QueryDefs collection, and print them out to
the Immediate Window (accessed by Ctrl-G). Assign the following code to the
OnClick procedure of a temporary command button and press.

Dim db As Database
Dim qry As QueryDef
Set db = CurrentDb()

For Each qry In db.QueryDefs
Debug.Print qry.Name
Next qry
Set db = Nothing

Hope that helps.
Sprinks

 

[Guest]

In a query:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Name Not Like "~*"
AND MSysObjects.Type = 5
ORDER BY MSysObjects.Name;

 

[Guest]

you are my hero! thank you thank you

In a query:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Name Not Like "~*"
AND MSysObjects.Type = 5
ORDER BY MSysObjects.Name;

 

[Guest]

Here's a list of some of the other types:
1 TABLE
5 QUERY
6 TABLE LINKED
8 RELATIONSHIPS
-32756 PAGE
-32761 MODULE
-32764 REPORT
-32766 MACRO
-32768 FORM

 

[Guest]

Jerry,

Thanks; this is a better way.

Sprinks

Here's a list of some of the other types:
1 TABLE
5 QUERY
6 TABLE LINKED
8 RELATIONSHIPS
-32756 PAGE
-32761 MODULE
-32764 REPORT
-32766 MACRO
-32768 FORM

 

[Albert D.Kallal]

There is a built in database documenter..and you don't need to wite any
code.

Toos->analyse->documenter..

The above will printout all you need....

 

[Guest]

While that's true, Albert, the documeter includes much more information than
is often required. If a simple list is all that's required, the SQL Jerry
provided is quite handy.

Sprinks

 

[Guest]

Is there any way to modify Jerry's code to include the SQL of the query?

I'd be interested in this less for training purposes and more for
documentation purposes. (As to built in documentation tool: I think it's an
unwieldy piece of crap.)

Thanks,

Dave

 

[dbahooker]

sp_helpText 'myqueryname'

or if you're a baby and you still use MDB; you can use the .SQL method
of the querydef object