A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data Dictionary



 
 
Thread Tools Display Modes
  #1  
Old January 28th, 2005, 12:45 AM
Cindy H
external usenet poster
 
Posts: n/a
Default Data Dictionary

Hi,



I need to create a list of all the data elements used in my project. The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to extract
the description so I don't have to retype all this info to create a data
element dictionary?



Thanks, Cindy H


  #2  
Old January 28th, 2005, 12:56 AM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default

Public Sub ListDescriptions()

Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim fld As DAO.Field

Set db = CurrentDb
For Each tdf In db.TableDefs
If Left$(tdf.Name, 4) "MSys" Then
For Each fld In tdf.Fields
Debug.Print tdf.Name, fld.Name, ;
On Error Resume Next
Debug.Print fld.Properties("Description");
On Error GoTo 0
Debug.Print
Next fld
End If
Next tdf

End Sub

--
Brendan Reynolds (MVP)


"Cindy H" wrote in message
...
Hi,



I need to create a list of all the data elements used in my project. The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the
Tools-Analyze-Documenter, but it does not show the description column
data. Any ideas how to extract the description so I don't have to retype
all this info to create a data element dictionary?



Thanks, Cindy H




  #3  
Old January 28th, 2005, 03:31 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

The descriptions should show if you select to display field properties.

--
Duane Hookom
MS Access MVP


"Cindy H" wrote in message
...
Hi,



I need to create a list of all the data elements used in my project. The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the
Tools-Analyze-Documenter, but it does not show the description column
data. Any ideas how to extract the description so I don't have to retype
all this info to create a data element dictionary?



Thanks, Cindy H




  #4  
Old January 28th, 2005, 04:10 AM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

I created an Access Add-In called the "John Viescas Table Documentor"
that does exactly this. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

Once installed (takes less than a minute) all you have to do is
Tools | Add-Ins | John Viescas Table Documentor. Poof!
After a few seconds a slick report is displayed on the screen. Easy as pie!

I am awaiting word back from John about the possibility of having him post
it on his web site where anyone can download it. In the meantime, I do not
believe he would have a problem if I sent you a copy. If you do wish to have
a copy please let me know where you would like it sent to (please mung the
e-mail address so you won't get spammed!). There is one version for Access
97 and one for 2000 which works with Access 2000, 2002, and 2003.
I will need to know which version you need.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Cindy H" wrote in message ...
Hi,



I need to create a list of all the data elements used in my project. The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to extract
the description so I don't have to retype all this info to create a data
element dictionary?



Thanks, Cindy H



  #5  
Old January 28th, 2005, 05:28 PM
Cindy H
external usenet poster
 
Posts: n/a
Default

Thanks Brendan, worked!

"Brendan Reynolds" brenreyn at indigo dot ie wrote in message
...
Public Sub ListDescriptions()

Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim fld As DAO.Field

Set db = CurrentDb
For Each tdf In db.TableDefs
If Left$(tdf.Name, 4) "MSys" Then
For Each fld In tdf.Fields
Debug.Print tdf.Name, fld.Name, ;
On Error Resume Next
Debug.Print fld.Properties("Description");
On Error GoTo 0
Debug.Print
Next fld
End If
Next tdf

End Sub

--
Brendan Reynolds (MVP)


"Cindy H" wrote in message
...
Hi,



I need to create a list of all the data elements used in my project. The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the
Tools-Analyze-Documenter, but it does not show the description column
data. Any ideas how to extract the description so I don't have to retype
all this info to create a data element dictionary?



Thanks, Cindy H






  #6  
Old January 29th, 2005, 12:09 AM
dave h
external usenet poster
 
Posts: n/a
Default

Hi Jeff,

I couldn't seem to email you directly, but I'd sure appreciate a copy of
your Add-in"

My email is the one you see on a reply. Thanks

"Jeff Conrad" wrote in message
...
I created an Access Add-In called the "John Viescas Table Documentor"
If you do wish to have
a copy please let me know where you would like it sent to
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Cindy H" wrote in message

...
Hi,



I need to create a list of all the data elements used in my project.

The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the

Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to

extract
the description so I don't have to retype all this info to create a data
element dictionary?



Thanks, Cindy H





  #7  
Old January 29th, 2005, 12:22 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

I think this is the same file
http://members.rogers.com/douglas.j....ocumentor.html

--
Duane Hookom
MS Access MVP
--

"dave h" wrote in message
...
Hi Jeff,

I couldn't seem to email you directly, but I'd sure appreciate a copy of
your Add-in"

My email is the one you see on a reply. Thanks

"Jeff Conrad" wrote in message
...
I created an Access Add-In called the "John Viescas Table Documentor"
If you do wish to have
a copy please let me know where you would like it sent to
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Cindy H" wrote in message

...
Hi,



I need to create a list of all the data elements used in my project.

The
list needs to include the descriptions that I typed into the
description
column of the table design view. I've tried the

Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to

extract
the description so I don't have to retype all this info to create a
data
element dictionary?



Thanks, Cindy H







  #8  
Old January 29th, 2005, 12:39 AM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

Hi Dave,

My posted e-mail address goes to Never-Never Land.
Keeps the SPAM down.

Sure I can send you a copy.
Do you need the Access 97 version or the 2000 version?
The 2000 version works with 2000, 2002, and 2003.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"dave h" e-mail snipped wrote in message
...

Hi Jeff,

I couldn't seem to email you directly, but I'd sure appreciate a copy of
your Add-in"

My email is the one you see on a reply. Thanks

"Jeff Conrad" wrote in message
...
I created an Access Add-In called the "John Viescas Table Documentor"
If you do wish to have
a copy please let me know where you would like it sent to
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Cindy H" wrote in message

...
Hi,



I need to create a list of all the data elements used in my project.

The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the

Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to

extract
the description so I don't have to retype all this info to create a data
element dictionary?



Thanks, Cindy H



  #9  
Old January 29th, 2005, 12:43 AM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

Hi Duane,

That link is for my "Doug Steele Object Documentor" which will
give a nice slick report of all the database objects. Dave was looking
for my "John Viescas Table Documentor" which produces a real nice
report of each table's Fields, Descriptions, Type, Length, and which
field(s) is the Primary Key. I am still awaiting word back from John
on the possibility of him posting it on his web site.

Would you like a copy as well?

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Duane Hookom" wrote in message
...
I think this is the same file
http://members.rogers.com/douglas.j....ocumentor.html

--
Duane Hookom
MS Access MVP
--

"dave h" wrote in message
...
Hi Jeff,

I couldn't seem to email you directly, but I'd sure appreciate a copy of
your Add-in"

My email is the one you see on a reply. Thanks

"Jeff Conrad" wrote in message
...
I created an Access Add-In called the "John Viescas Table Documentor"
If you do wish to have
a copy please let me know where you would like it sent to
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Cindy H" wrote in message

...
Hi,



I need to create a list of all the data elements used in my project.

The
list needs to include the descriptions that I typed into the
description
column of the table design view. I've tried the

Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to

extract
the description so I don't have to retype all this info to create a
data
element dictionary?



Thanks, Cindy H



  #10  
Old January 29th, 2005, 03:49 AM
dave h
external usenet poster
 
Posts: n/a
Default

2000 - thanks again.

"Jeff Conrad" wrote in message
...
Hi Dave,

My posted e-mail address goes to Never-Never Land.
Keeps the SPAM down.

Sure I can send you a copy.
Do you need the Access 97 version or the 2000 version?
The 2000 version works with 2000, 2002, and 2003.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"dave h" e-mail snipped wrote in message
...

Hi Jeff,

I couldn't seem to email you directly, but I'd sure appreciate a copy of
your Add-in"

My email is the one you see on a reply. Thanks

"Jeff Conrad" wrote in message
...
I created an Access Add-In called the "John Viescas Table Documentor"
If you do wish to have
a copy please let me know where you would like it sent to
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Cindy H" wrote in message

...
Hi,



I need to create a list of all the data elements used in my project.

The
list needs to include the descriptions that I typed into the

description
column of the table design view. I've tried the

Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to

extract
the description so I don't have to retype all this info to create a

data
element dictionary?



Thanks, Cindy H





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I need an explanation to a line in a code for a Data Dictionary RedCentreLPlater New Users 2 October 27th, 2004 10:05 AM
Creating Data Dictionary shuchi General Discussion 4 September 15th, 2004 04:10 AM
Mial merge data base problems Rachael Mailmerge 16 May 21st, 2004 06:22 PM


All times are GMT +1. The time now is 02:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.