Table Field Description - need to copy

[Guest]

I am working with a db that I did not create and have only been in a few
times. The original designer (now gone) was working from questionnaires and
has coded the field names in the tables based from the questionnaires. We
are now trying to create a data dictionary (attach descriptions to the code
names) and I was hoping just to copy/paste or export the field descriptions
from the table in design view. I can't copy/paste or export (that I have
found) does anyone have an idea how to accomplish this? Thx

 

[Larry Linson]

I am working with a db that I did not create and have only been in a few
times. The original designer (now gone) was working from questionnaires
and
has coded the field names in the tables based from the questionnaires. We
are now trying to create a data dictionary (attach descriptions to the
code
names) and I was hoping just to copy/paste or export the field
descriptions
from the table in design view. I can't copy/paste or export (that I have
found) does anyone have an idea how to accomplish this? Thx

What do you want to copy/paste/export them _TO_?

You can certainly copy and paste, individual descriptions, but I suspect
what you mean is you can't do so in one hightlight, copy, and paste
operation, the way you'd prefer.

IIRC, the Description of the Field is a Property that could be accessed from
code, and you can control the other software in Microsoft Office via COM
Automation, so this could be done from VBA code -- but it's not a "beginner
level" newsgroup response. It would be simpler to learn enough to write VBA
code to write a text file with table and field names and the descriptions.

There are third-party documentation software packages available. The
Database Documenter that is built into Access might be a start, but may not
fill your needsI believe MVP Jeff Conrad has a free one at his
http://home.bendbroadband.com/conradsystems/. FMS, Inc., has Total Access
Analyzer and various packages at http://www.fmsinc.com. There may be another
or two in the links if you Google "Microsoft Access Data Dictionary," or use
http://groups.google.com to search this newsgroup and the USENET newsgroup
comp.databases.ms-access for discussions of documenting Microsoft Access
databases.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

And, with only a little searching, I found the reference I thought I
remembered, at MVP Allen Brown's site, http://allenbrowne.com/func-06.html.
Take a look and see if that helps.

Larry Linson
Microsoft Access MVP

 

[Guest]

Is there a way that i can CHANGE the field description?