Dear experts,
My first post in the forum, exciting!
For documenting purposes, among other properties, I am trying to retrieve the description (if any) of a queryfield in VBA. To be clear: I am not looking for the description of the query itself, but for the description of the fields/columns in the query (in design view you can see this in when you click in a field. On the right side of the screen the properties of the field appears, with description on the top)
With select queries, I succeeded via the fields collection of the querydef object. But for action queries there seems not to be a fieldscollection (it is empty), so I am not able to retrieve the description. I am not sure if I do it the wrong way or that it simply does not have a fieldscollection the same way a select query (or table) does.
By the way, I am working in Access 2016, desktop version.
Does anybody knows a way to retrieve the description (and other properties) of fields in an action query in VBA?
I hope you experts can help me out!
Kind regards,
Ron
My first post in the forum, exciting!
For documenting purposes, among other properties, I am trying to retrieve the description (if any) of a queryfield in VBA. To be clear: I am not looking for the description of the query itself, but for the description of the fields/columns in the query (in design view you can see this in when you click in a field. On the right side of the screen the properties of the field appears, with description on the top)
With select queries, I succeeded via the fields collection of the querydef object. But for action queries there seems not to be a fieldscollection (it is empty), so I am not able to retrieve the description. I am not sure if I do it the wrong way or that it simply does not have a fieldscollection the same way a select query (or table) does.
By the way, I am working in Access 2016, desktop version.
Does anybody knows a way to retrieve the description (and other properties) of fields in an action query in VBA?
I hope you experts can help me out!
Kind regards,
Ron