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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |