I have a query that prints out a list of database objects.  I would like to
add the property description that is visible in the object list pane.  Does
anybody know how to retrieve this?

SELECT MSysObjects.Name, "Query" AS Object," " as Comment
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "*~*") AND ((MSysObjects.Type)=5))
UNION
SELECT MSysObjects.Name, "Table" AS Object," " as Comment
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "*msys*") AND ((MSysObjects.Type)=1))
UNION
SELECT MSysObjects.Name, "Report" AS Object," " as Comment
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "*~*") AND ((MSysObjects.Type)=-32764))
UNION SELECT MSysObjects.Name, "Forms" AS Object," " as Comment
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "*~*") AND ((MSysObjects.Type)=-32768))
ORDER BY 2, 1;

thank you in advance,
Claudette Hennessy