[MS_AccessPros] Print table field specifications

Thanks, Duane. I don't see a path like this but will keep poking around.
I'm using Windows 7 Pro in a virtual machine on a Mac, and that may make a
difference.

James
www.james-mc.com
Words To Live By


On Mon, Dec 31, 2012 at 2:09 PM, Duane Hookom
<duanehookom@hotmail.com<javascript:_e({}, 'cvml',
'duanehookom@hotmail.com');>
> wrote:

> **
>
>
> 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 <javascript:_e({}, 'cvml',
> 'forums01%40james-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
>
>
>



--

James
www.james-mc.com
Words To Live By


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/