James,
You can link to or import the table created by the documenter and then use it as the base for a crosstab query. The table name is doc_tblObjects and you can find it in a folder like:
C:\Users\<your user name>\AppData\Roaming\Microsoft\Access\ACWZUSR12.ACCDU (your folder may vary).
The SQL view of the crosstab is:
TRANSFORM Min(Left([doc_tblObjects_2]![Extra1],100)) AS Expr1
SELECT doc_tblObjects_1.Name AS TableName, doc_tblObjects.Name AS FieldName, doc_tblObjects.Extra2 AS FieldType, doc_tblObjects.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_2 INNER JOIN (doc_tblObjects INNER JOIN doc_tblObjects AS doc_tblObjects_1 ON doc_tblObjects.ParentID = doc_tblObjects_1.ID) ON doc_tblObjects_2.ParentID = doc_tblObjects.ID
WHERE (((doc_tblObjects.TypeID)=11))
GROUP BY doc_tblObjects_1.Name, doc_tblObjects.Name, doc_tblObjects.Extra2, doc_tblObjects.Extra3
PIVOT doc_tblObjects_2.Name;
Duane Hookom MVP
MS Access
----------------------------------------
> From: forums01@james-mc.com
>
> I'm trying to use the built-in database documenter in Access 2010 to print
> the field specifications for one of my tables for a meeting. All I really
> need to see are the field name, type, size and description, but the
> documenter gives far more detail than this. Is there some other way I might
> get to just the name, type, size and description?
>
> Thanks!!
>
> James
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar