Print Id`s

  • Thread starter Thread starter Newbie!
  • Start date Start date
N

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
 
Hi Allen - could you be a bit more cryptic? This may be too easy for us
newbies to guess. Thanks ;)
 
-----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
Click to expand...
Tools, Analyze, Documenter
 
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
Click to expand...

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!
 
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).
 
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,
 
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
 
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)
 
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.
 
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
 
Back
Top