Print Id`s

[Newbie!]

Hi Group,

Anybody know if its possible from Access 2000 to print of a list of each
table and whats its propertys is? Eg feild size, field type ect etc?

Ta
Si

 

[Allen Browne]

Answered in comp.databases.ms-access

 

[Howard Cross]

Hi Allen - could you be a bit more cryptic? This may be too easy for us
newbies to guess. Thanks

 

[Roxie Aho]

-----Original Message-----
Hi Group,

Anybody know if its possible from Access 2000 to print of a list of each
table and whats its propertys is? Eg feild size, field type ect etc?

Ta
Si

Tools, Analyze, Documenter

 

[John Vinson]

Hi Group,

Anybody know if its possible from Access 2000 to print of a list of each
table and whats its propertys is? Eg feild size, field type ect etc?

Ta
Si

Tools... Analyze... Documentor on the menu.

Either review and adjust the Options on the documentation, or stock up
on paper - whoever programmed this must own stock in paper companies!

 

[Allen Browne]

The poster posted the same question in another newsgroup (not on the
Microsoft server), under a different subject. I already answered his
question in the other newsgroup.

In general, it is best to post to only the group you think is the most
appropriate. If you must post to more than one, in many of the newsgroup
readers you can specifiy multiple groups in the Newsgroups field, and then
the different groups track the same thread, so everyone does not have to
write everything twice.

If you are working from some interface that does not have the group
comp.databases.ms-access, you can search for the answers at
http://groups.google.com (Advanced search).

 

[Howard Cross]

Hi Allen,

I didn't realize you meant that this was a Google group. I was looking for
the server and didn't see it. Thanks for the clarification,

 

[John Marshall, MVP]

I find the documentor a bit verbose. Does anyone have a VBA example of
listing the tables and their fields.

I need something between the short version of Documenter and the one that
lists all the properties. I should post a wish for a selection box to be
able to choose which properties are displayed.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm

 

[Douglas J. Steele]

Assuming you've got a reference set to DAO, try the following untested
air-code:

Sub ListTablesAndFields()

Dim dbCurr As DAO.Database
Dim tdfCurr As DAO.TableDef
Dim fldCurr As DAO.Field

Set dbCurr = CurrentDb()
For Each tdfCurr In dbCurr.TableDefs
If (tdfCurr.Attributes And dbSystemObject) = 0 Then
Debug.Print tdfCurr.Name
For Each fldCurr In tdfCurr.Fields
Debug.Print fldCurr.Name
Next fldCurr
End If
Next tdfCurr

End Sub

However, the built-in Documenter does have the option to control what gets
displayed. Check out the Options button in the bottom right-hand corner.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

 

[Duane Hookom]

I also find the documenter a bit too structured. The good news is that you
can use all the generated information however you want. All of the
information (Access 2000 and later) is stored in a table that you can link
to. On my XP system, the table and file the connection is:
DATABASE=C:\Documents and Settings\Duane Hookom\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblObjects
The table doc_tblObjects can be self-joined to create your own
queries/reports.
A simple query of tables, field, types, and sizes is:
SELECT doc_tblObjects.Name AS TableName,
doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType,
doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_1
INNER JOIN doc_tblObjects ON doc_tblObjects_1.ParentID =
doc_tblObjects.ID
WHERE (((doc_tblObjects_1.TypeID)=11));

I have also created crosstabs from the table that list all fields as Row
Headings and tables as Column Headings. This provides a cross-reference of
which fields are common to which tables.

 

[John Marshall, MVP]

Thanks Doug. I had looked at the Options button, but the refinement I was
looking for was to select the properties to be displayed. With the
Documentor, it is all or none.

With a little bit of googling, I found some sample code from Al Browne that
displays the content of the tables and includes code to interpret the field
type. http://members.iinet.net.au/~allenbrowne/func-06.html

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm