Re: [MS_AccessPros] Re: Print table field specifications

Thanks, Bill! ANother option!

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


On Tue, Jan 1, 2013 at 11:45 AM, Bill Mosca <wrmosca@comcast.net> wrote:

> **
>
>
> James
>
> If Clive's sample isn't what you want take a look at Crystal's Database
> analyzer. It's in
> Files>Crystal>bas_Crystal_DataDictionary_ReservedWords.zip
>
> Because it is a .bas file, you can import it by opening the VBA code
> window and
> click on File>Import.
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT http://thatlldoit.com
> MS Access MVP
>
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My Nothing-to-do-with Access blog
> http://wrmosca.wordpress.com
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of James
> McAlister
> Sent: Tuesday, January 01, 2013 8:02 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: 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
>
>
>


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