Query to Return: Field Names, Data Type and Description

[Jorge Ramos]

Hello all,

I would like to create a query that will return the (i) field names, (ii)
"data type" and (iii) "description" on any given table (as one can see these
three on a table when opened in Design View). My interest is to have the
data returned on a query and not a report. The Access "Documenter" can
produce a report with most, but not all, of the information. Documenter can
not show the "description".

Any ideas?

 

[Allen Browne]

Access does not expose this where you can get it in a query, but you can get
it programmatically like this:
http://allenbrowne.com/func-06.html

The code just displays the info (including Description) in the immediate
window.

 

[Jorge Ramos]

Allen, your code works great!! Thank you!!

Access does not expose this where you can get it in a query, but you can
get it programmatically like this:
http://allenbrowne.com/func-06.html

The code just displays the info (including Description) in the immediate
window.