structure of a access table
- Thread starter yogi
- Start date
- Local time
- Today, 08:53
- Joined
- Feb 28, 2001
- Messages
- 30,196
? First, this is re-inventing a wheel, because the Documenter under the Tools menu will create this for you without having to do any coding at all.
Having said that: Do you mean, make a listing of what a record looks like structurally using VBA only? I'll answer that question by pointing to reading material.
A table is defined in a TableDef, which is part of the TableDefs Collection. Both TableDef and the TableDefs collection are addressed in Access Help on those topics. A TableDef includes a FieldDefs collection, which contains FieldDef entries. (Again, Access Help will explain these items.)
To build the description you named, what you need to do is
1. Navigate the TableDefs collection to find your desired table.
2. Look at the overall table properies.
3. Find the FieldDefs collection.
4. For each FieldDef, examine - and report on - its properties.
You can use the Object Browser (generally visible from a Code window) to see the FieldDef object, which will include a TYPE property. The Browser will enumerate the list of known field types if you follow the links and drill down enough.
Having said that: Do you mean, make a listing of what a record looks like structurally using VBA only? I'll answer that question by pointing to reading material.
A table is defined in a TableDef, which is part of the TableDefs Collection. Both TableDef and the TableDefs collection are addressed in Access Help on those topics. A TableDef includes a FieldDefs collection, which contains FieldDef entries. (Again, Access Help will explain these items.)
To build the description you named, what you need to do is
1. Navigate the TableDefs collection to find your desired table.
2. Look at the overall table properies.
3. Find the FieldDefs collection.
4. For each FieldDef, examine - and report on - its properties.
You can use the Object Browser (generally visible from a Code window) to see the FieldDef object, which will include a TYPE property. The Browser will enumerate the list of known field types if you follow the links and drill down enough.
Similar threads
