S
SAC
I'd like to document the tables in my mdb and have a description for each
field which I've entered in the design view of each table. I've tried the
Analyzer but it doesn't allow the description of a field to be displayed
without all the properties displaying and I'd rather not have all of them.
I can go through the table names like this:
Function fExistTable()
Dim db As Database
Dim i As Integer
Set db = DBEngine.Workspaces(0).Databases(0)
db.TableDefs.Refresh
For i = 0 To db.TableDefs.Count - 1
MsgBox (db.TableDefs(i).Name)
Next i
Set db = Nothing
End Function
But then how do I display (eventually I'll print) the field properties I
want for each table?
Thanks.
field which I've entered in the design view of each table. I've tried the
Analyzer but it doesn't allow the description of a field to be displayed
without all the properties displaying and I'd rather not have all of them.
I can go through the table names like this:
Function fExistTable()
Dim db As Database
Dim i As Integer
Set db = DBEngine.Workspaces(0).Databases(0)
db.TableDefs.Refresh
For i = 0 To db.TableDefs.Count - 1
MsgBox (db.TableDefs(i).Name)
Next i
Set db = Nothing
End Function
But then how do I display (eventually I'll print) the field properties I
want for each table?
Thanks.