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