Data Dictionary (more help)

[rocketD]

Hi All,

I've been using this code from Allen Browne to get the field names and
descriptions out of Access:
http://allenbrowne.com/func-06.html

The problem is, I've found that there are some tables in the database
which have too many field names to fit in the Immediate Window, so I
only get a partial list of the fields. Is there a way to either
extend the size of the immediate window so it shows more rows of data,
or call the module from a form in which I type in the table name and
have it output the list of fields to a Word or notepad file? I don't
know VBA well at all.

Thanks,
Dara

 

[Albert D. Kallal]

Have you tried the database documenter?

(the documenter does not include "description" fields, but does build
reports, and those reports can be put in landscape mode, or even sent to
word....

 

[Duane Hookom]

After using the documenter, you can create custom reports using the solution
found at http://www.access.hookom.net/Documenter/.

 

[rocketD]

After using the documenter, you can create custom reports using the solution
found athttp://www.access.hookom.net/Documenter/.

--
Duane Hookom
Microsoft Access MVP






- Show quoted text -

Thanks to both of you. I hadn't tried the documenter, but after
playing around with it a bit, I got the info I needed and was able to
extract it and clean it up to put into an Excel spreadsheet as
requested. I think it's a faster method even than the one I was using
before.

Cheers,
Dara