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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar