Re: [MS_AccessPros] Re: Print table field specifications

Thanks, Clive! I'll have a look!

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


On Tue, Jan 1, 2013 at 6:26 AM, Clive <zctek@aol.com> wrote:

> **
>
>
> Hi James,
>
> I have uploaded a file, DispTable.mdb, to the
> Assistance_Needed Folder.
>
> It was written as part of collection of modules
> for displaying DB Information. It was written a
> long time ago and is not fit for public consumption
> so I stripped out a part of it and modified it to
> show the details of a single table.
>
> It should be easy for you to modify it to change
> the details and layout. It was originally able to
> print the results to a file and some remnants are in
> the code but will not be used.
>
> Hope that helps.
>
> Regards, Clive.
>
>
> --- In MS_Access_Professionals@yahoogroups.com, James McAlister <forums01@...>
> wrote:
> >
> > 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@...<javascript:_e({}, 'cvml',
> > 'duanehookom@...');>
> > > 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@... <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]
> >
>
>
>


[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/