Field Descriptions

[Martin]

Hello,

I have a query based on a table that has a description in each field. When
the query runs, I can click on the field and the description appears in the
status bar as it should.

I export this query to an Excel workbook using the transfer spreadsheet
method. Is there any way to export these field descriptions from the query?
The fields in the query may change, depending on the user.

Any help on this would be much appreciated.

Martin

 

[David H]

To my knowledge, the only way to do something like that would be to use VBA
to get the value directly from the underlying table given the coding needed
to get to the Description property you would most likely have to wrap it in
your own SUB that creates the export.