How To Export Table Structure Including Description

[RobH]

I want to export my table structures into a list, but i need to see the description details as well.

Anyone ???

[ADezii]

I want to export my table structures into a list, but i need to see the description details as well.

Anyone ???

In order to obtain comprehensive documentation on a Table and its Fields, take these steps in sequence:

1. Tools
2. Analyze
3. Documenter
4. Tables Tab
5. Select Table(s)
6. Options
7. Select Include Options
8. OK
9. OK

[RobH]

Sorry - Should Have Mentioned Access 2007

[ADezii]

Sorry - Should Have Mentioned Access 2007

Sorry, but I can't help you there. I'm not sure if Access 2007 has the same Documenter functionality. You could always, of course, write code to accomplish pretty much the same thing.

[RobH]

I wasnt aware that you could view that from within Access itself

[ADezii]

I wasnt aware that you could view that from within Access itself

Yes, RobH - it can be done via VBA. I've written some simple code that will write the Properties of the Employees Table in Northwind.mdb, list all the Fields in the Employees Table along with their Properties and associated Values, to a file named Table Structure.txt in C:\. This code can be modified to include all Tables as well.
On Error Resume Next

DoCmd.Hourglass True

[CODE=vb]Open "C:\Table Structure.txt" For Output As #1

Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim prp As DAO.Property, fldprp As DAO.Property
Dim fld As DAO.Field

Set db = CurrentDb()

Set tdf = db.TableDefs("E mployees")

For Each prp In tdf.Properties
Print #1, "|--- " & prp.Name & " ==> " & prp.Value
Next prp
Print #1, "---------------------------------------------------------"
For Each fld In tdf.Fields
Print #1, "|--- " & fld.Name & " (Field in " & tdf.Name & ")"
For Each fldprp In fld.Properties
Print #1, "|------ " & fldprp.Name & " ==> " & fldprp.Value
Next
Next
'Next prp

Close #1

DoCmd.Hourglass False[/CODE]
Contents of Table Structure.txt:
[CODE=text]|--- Name ==> Employees
|--- Updatable ==> True
|--- DateCreated ==> 2/2/2007 8:06:39 PM
|--- LastUpdated ==> 5/22/2007 11:51:42 AM
|--- Connect ==>
|--- Attributes ==> 0
|--- SourceTableName ==>
|--- RecordCount ==> 16
|--- ValidationRule ==>
|--- ValidationText ==>
|--- ConflictTable ==>
|--- ReplicaFilter ==>
|--- Orientation ==> 0
|--- OrderByOn ==> True
|--- NameMap ==> ?? ???????? ???? Employees ???????? ????????Primary Key ???????? ????????Employe eID ???????? ????????LastNam e ???????? ????????FirstNa me ???????? ????????Title ???????? ????????TitleOf Courtesy ???????? ????????BirthDa te ???????? ????????HireDat e ???????? ????????Address ???????? ????????City ???????? ????????Region ???????? ????????PostalC ode ???????? ????????Country ???????? ????????HomePho ne ???????? ????????Extensi on ???????? ????????Photo ???????? ????????Notes ???????? ????????Reports To ???????? ????????PhotoPa th ?o?????? ????????SomeFie ld ???????? ????????TimeObs erved ???????? ????????Full ???????? ????????CREW ???????? ????????File
|--- DefaultView ==> 2
|--- GUID ==> ????????
---------------------------------------------------------
|--- PrimaryKey (Field in Employees)
|------ Attributes ==> 17
|------ CollatingOrder ==> 1033
|------ Type ==> 4
|------ Name ==> PrimaryKey
|------ OrdinalPosition ==> 0
|------ Size ==> 4
|------ SourceField ==> PrimaryKey
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ GUID ==> ????????
|--- EmployeeID (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 4
|------ Name ==> EmployeeID
|------ OrdinalPosition ==> 1
|------ Size ==> 4
|------ SourceField ==> EmployeeID
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> True
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DecimalPlaces ==> 255
|------ DisplayControl ==> 109
|------ GUID ==> ????????
|--- LastName (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> LastName
|------ OrdinalPosition ==> 2
|------ Size ==> 20
|------ SourceField ==> LastName
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> True
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> 3180
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- FirstName (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> FirstName
|------ OrdinalPosition ==> 3
|------ Size ==> 10
|------ SourceField ==> FirstName
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> True
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- Title (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Title
|------ OrdinalPosition ==> 4
|------ Size ==> 30
|------ SourceField ==> Title
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- TitleOfCourtesy (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> TitleOfCourtesy
|------ OrdinalPosition ==> 5
|------ Size ==> 25
|------ SourceField ==> TitleOfCourtesy
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- BirthDate (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 8
|------ Name ==> BirthDate
|------ OrdinalPosition ==> 6
|------ Size ==> 8
|------ SourceField ==> BirthDate
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ GUID ==> ????????
|--- HireDate (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 8
|------ Name ==> HireDate
|------ OrdinalPosition ==> 7
|------ Size ==> 8
|------ SourceField ==> HireDate
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ GUID ==> ????????
|--- Address (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Address
|------ OrdinalPosition ==> 8
|------ Size ==> 60
|------ SourceField ==> Address
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- City (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> City
|------ OrdinalPosition ==> 9
|------ Size ==> 15
|------ SourceField ==> City
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- Region (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Region
|------ OrdinalPosition ==> 10
|------ Size ==> 50
|------ SourceField ==> Region
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- PostalCode (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> PostalCode
|------ OrdinalPosition ==> 11
|------ Size ==> 10
|------ SourceField ==> PostalCode
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- Country (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Country
|------ OrdinalPosition ==> 12
|------ Size ==> 15
|------ SourceField ==> Country
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- HomePhone (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> HomePhone
|------ OrdinalPosition ==> 13
|------ Size ==> 24
|------ SourceField ==> HomePhone
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- Extension (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Extension
|------ OrdinalPosition ==> 14
|------ Size ==> 4
|------ SourceField ==> Extension
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- Photo (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 11
|------ Name ==> Photo
|------ OrdinalPosition ==> 15
|------ Size ==> 0
|------ SourceField ==> Photo
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ GUID ==> ????????
|--- Notes (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 12
|------ Name ==> Notes
|------ OrdinalPosition ==> 16
|------ Size ==> 0
|------ SourceField ==> Notes
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- ReportsTo (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 4
|------ Name ==> ReportsTo
|------ OrdinalPosition ==> 17
|------ Size ==> 4
|------ SourceField ==> ReportsTo
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DecimalPlaces ==> 255
|------ DisplayControl ==> 109
|------ GUID ==> ????????
|--- PhotoPath (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> PhotoPath
|------ OrdinalPosition ==> 18
|------ Size ==> 255
|------ SourceField ==> PhotoPath
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- SomeField (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> SomeField
|------ OrdinalPosition ==> 19
|------ Size ==> 50
|------ SourceField ==> SomeField
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> True
|------ GUID ==> ?o??????
|--- TimeObserved (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 8
|------ Name ==> TimeObserved
|------ OrdinalPosition ==> 20
|------ Size ==> 8
|------ SourceField ==> TimeObserved
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ InputMask ==> 00:00;0;_
|------ GUID ==> ????????
|--- Full (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Full
|------ OrdinalPosition ==> 21
|------ Size ==> 50
|------ SourceField ==> Full
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> True
|------ GUID ==> ????????
|--- CREW (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> CREW
|------ OrdinalPosition ==> 22
|------ Size ==> 50
|------ SourceField ==> CREW
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> True
|------ GUID ==> ????????
|--- File (Field in Employees)
|------ Attributes ==> 32770
|------ CollatingOrder ==> 1033
|------ Type ==> 12
|------ Name ==> File
|------ OrdinalPosition ==> 23
|------ Size ==> 0
|------ SourceField ==> File
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> True
|------ GUID ==> ????????[/CODE]

[Scott Price]

Yes, RobH - it can be done via VBA. I've written some simple code that will write the Properties of the Employees Table in Northwind.mdb, list all the Fields in the Employees Table along with their Properties and associated Values, to a file named Table Structure.txt in C:\. This code can be modified to include all Tables as well.

Why are you empty, my friend?? Is this what you were trying to post?

Kind regards,
Scott

Note to all, by clicking on the Reply button you can see the whole of the last post by ADezii... I'll try to add the code he posted in another Reply window.

[Scott Price]

[CODE=vb]On Error Resume Next

DoCmd.Hourglass True

Open "C:\Table Structure.txt" For Output As #1

Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim prp As DAO.Property, fldprp As DAO.Property
Dim fld As DAO.Field

Set db = CurrentDb()

Set tdf = db.TableDefs("E mployees")

For Each prp In tdf.Properties
Print #1, "|--- " & prp.Name & " ==> " & prp.Value
Next prp
Print #1, "---------------------------------------------------------"
For Each fld In tdf.Fields
Print #1, "|--- " & fld.Name & " (Field in " & tdf.Name & ")"
For Each fldprp In fld.Properties
Print #1, "|------ " & fldprp.Name & " ==> " & fldprp.Value
Next
Next
'Next prp

Close #1

DoCmd.Hourglass False[/CODE]
Contents of Table Structure.txt:
[CODE=text]|--- Name ==> Employees
|--- Updatable ==> True
|--- DateCreated ==> 2/2/2007 8:06:39 PM
|--- LastUpdated ==> 5/22/2007 11:51:42 AM
|--- Connect ==>
|--- Attributes ==> 0
|--- SourceTableName ==>
|--- RecordCount ==> 16
|--- ValidationRule ==>
|--- ValidationText ==>
|--- ConflictTable ==>
|--- ReplicaFilter ==>
|--- Orientation ==> 0
|--- OrderByOn ==> True
|--- NameMap ==> ?? ???????? ???? Employees ???????? ????????Primary Key ???????? ????????Employe eID ???????? ????????LastNam e ???????? ????????FirstNa me ???????? ????????Title ???????? ????????TitleOf Courtesy ???????? ????????BirthDa te ???????? ????????HireDat e ???????? ????????Address ???????? ????????City ???????? ????????Region ???????? ????????PostalC ode ???????? ????????Country ???????? ????????HomePho ne ???????? ????????Extensi on ???????? ????????Photo ???????? ????????Notes ???????? ????????Reports To ???????? ????????PhotoPa th ?o?????? ????????SomeFie ld ???????? ????????TimeObs erved ???????? ????????Full ???????? ????????CREW ???????? ????????File
|--- DefaultView ==> 2
|--- GUID ==> ????????
---------------------------------------------------------
|--- PrimaryKey (Field in Employees)
|------ Attributes ==> 17
|------ CollatingOrder ==> 1033
|------ Type ==> 4
|------ Name ==> PrimaryKey
|------ OrdinalPosition ==> 0
|------ Size ==> 4
|------ SourceField ==> PrimaryKey
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ GUID ==> ????????
|--- EmployeeID (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 4
|------ Name ==> EmployeeID
|------ OrdinalPosition ==> 1
|------ Size ==> 4
|------ SourceField ==> EmployeeID
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> True
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DecimalPlaces ==> 255
|------ DisplayControl ==> 109
|------ GUID ==> ????????
|--- LastName (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> LastName
|------ OrdinalPosition ==> 2
|------ Size ==> 20
|------ SourceField ==> LastName
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> True
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> 3180
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- FirstName (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> FirstName
|------ OrdinalPosition ==> 3
|------ Size ==> 10
|------ SourceField ==> FirstName
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> True
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- Title (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Title
|------ OrdinalPosition ==> 4
|------ Size ==> 30
|------ SourceField ==> Title
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- TitleOfCourtesy (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> TitleOfCourtesy
|------ OrdinalPosition ==> 5
|------ Size ==> 25
|------ SourceField ==> TitleOfCourtesy
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- BirthDate (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 8
|------ Name ==> BirthDate
|------ OrdinalPosition ==> 6
|------ Size ==> 8
|------ SourceField ==> BirthDate
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ GUID ==> ????????
|--- HireDate (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 8
|------ Name ==> HireDate
|------ OrdinalPosition ==> 7
|------ Size ==> 8
|------ SourceField ==> HireDate
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ GUID ==> ????????
|--- Address (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Address
|------ OrdinalPosition ==> 8
|------ Size ==> 60
|------ SourceField ==> Address
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
|--- City (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> City
|------ OrdinalPosition ==> 9
|------ Size ==> 15
|------ SourceField ==> City
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==>
|------ ValidationRule ==>
|------ ValidationText ==>
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompress ion ==> False
|------ GUID ==> ????????
[/CODE]

[Scott Price]

|--- Region (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Region
|------ OrdinalPosition ==> 10
|------ Size ==> 50
|------ SourceField ==> Region
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> False
|------ GUID ==> ????????
|--- PostalCode (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> PostalCode
|------ OrdinalPosition ==> 11
|------ Size ==> 10
|------ SourceField ==> PostalCode
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> False
|------ GUID ==> ????????
|--- Country (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Country
|------ OrdinalPosition ==> 12
|------ Size ==> 15
|------ SourceField ==> Country
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> False
|------ GUID ==> ????????
|--- HomePhone (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> HomePhone
|------ OrdinalPosition ==> 13
|------ Size ==> 24
|------ SourceField ==> HomePhone
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> False
|------ GUID ==> ????????
|--- Extension (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Extension
|------ OrdinalPosition ==> 14
|------ Size ==> 4
|------ SourceField ==> Extension
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> False
|------ GUID ==> ????????
|--- Photo (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 11
|------ Name ==> Photo
|------ OrdinalPosition ==> 15
|------ Size ==> 0
|------ SourceField ==> Photo
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ GUID ==> ????????
|--- Notes (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 12
|------ Name ==> Notes
|------ OrdinalPosition ==> 16
|------ Size ==> 0
|------ SourceField ==> Notes
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> False
|------ GUID ==> ????????
|--- ReportsTo (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 4
|------ Name ==> ReportsTo
|------ OrdinalPosition ==> 17
|------ Size ==> 4
|------ SourceField ==> ReportsTo
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DecimalPlaces ==> 255
|------ DisplayControl ==> 109
|------ GUID ==> ????????
|--- PhotoPath (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> PhotoPath
|------ OrdinalPosition ==> 18
|------ Size ==> 255
|------ SourceField ==> PhotoPath
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> False
|------ GUID ==> ????????
|--- SomeField (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> SomeField
|------ OrdinalPosition ==> 19
|------ Size ==> 50
|------ SourceField ==> SomeField
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> True
|------ GUID ==> ?o??????
|--- TimeObserved (Field in Employees)
|------ Attributes ==> 1
|------ CollatingOrder ==> 1033
|------ Type ==> 8
|------ Name ==> TimeObserved
|------ OrdinalPosition ==> 20
|------ Size ==> 8
|------ SourceField ==> TimeObserved
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> False
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ InputMask ==> 00:00;0;_
|------ GUID ==> ????????
|--- Full (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> Full
|------ OrdinalPosition ==> 21
|------ Size ==> 50
|------ SourceField ==> Full
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> True
|------ GUID ==> ????????
|--- CREW (Field in Employees)
|------ Attributes ==> 2
|------ CollatingOrder ==> 1033
|------ Type ==> 10
|------ Name ==> CREW
|------ OrdinalPosition ==> 22
|------ Size ==> 50
|------ SourceField ==> CREW
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ DisplayControl ==> 109
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> True
|------ GUID ==> ????????
|--- File (Field in Employees)
|------ Attributes ==> 32770
|------ CollatingOrder ==> 1033
|------ Type ==> 12
|------ Name ==> File
|------ OrdinalPosition ==> 23
|------ Size ==> 0
|------ SourceField ==> File
|------ SourceTable ==> Employees
|------ DataUpdatable ==> False
|------ DefaultValue ==> 
|------ ValidationRule ==> 
|------ ValidationText ==> 
|------ Required ==> False
|------ AllowZeroLength ==> True
|------ ColumnWidth ==> -1
|------ ColumnOrder ==> 0
|------ ColumnHidden ==> False
|------ IMEMode ==> 0
|------ IMESentenceMode ==> 3
|------ UnicodeCompression ==> True
|------ GUID ==> ????????

Apparently the original was too long, this code section is broken in two sections...

Regards,
Scott

[ADezii]

Why are you empty, my friend?? Is this what you were trying to post?

Kind regards,
Scott

Note to all, by clicking on the Reply button you can see the whole of the last post by ADezii... I'll try to add the code he posted in another Reply window.

Thanks a million, Scott! There's nothing quite like taking the time to arrive at a viable solution to a problem, then being unable to Post it. I'll make sure Mary gives you both a Save and an Assist on this one. (LOL). Thanks again - I'm known as the 'Man of Few Words' but this was ridiculous.

[Scott Price]

Thanks a million, Scott! There's nothing quite like taking the time to arrive at a viable solution to a problem, then being unable to Post it. I'll make sure Mary gives you both a Save and an Assist on this one. (LOL). Thanks again - I'm known as the 'Man of Few Words' but this was ridiculous.

Nothing quite so frustrating!! I've had it happen to me before without warning... Still not sure why it happens each time, but I think this one was just length.

Regards,
Scott

[ADezii]

Nothing quite so frustrating!! I've had it happen to me before without warning... Still not sure why it happens each time, but I think this one was just length.

Regards,
Scott

I did ask Mary regarding this matter and her response is listed below.

http://www.thescripts.com/forum/private.php?do=showpm&pmid=45464

[RobH]

Thanks for the detail.. But... I was actually wanting something much simpler -

Something that would out put more like,

Field Name, Type, Description
EID, Number, Employee Staff ID Number
SD,Date, Employee Start Date

Something that gives me an easy ready reference to my table structures

[ADezii]

Thanks for the detail.. But... I was actually wanting something much simpler -

Something that would out put more like,

Field Name, Type, Description
EID, Number, Employee Staff ID Number
SD,Date, Employee Start Date

Something that gives me an easy ready reference to my table structures

The code I gave you is comprehensive, and covers a lot of area. What exactly are you looking for, Table Names along with Field Names, their Types and Descriptions? The code previously listed can easily be reduced to provide that information.

[MMcCarthy]

I did ask Mary regarding this matter and her response is listed below.

http://www.thescripts.com/forum/private.php?do=showpm&pmid=45464

I've deleted the other thread.