Recent content by RonaldF

Dear all, Sorry i didn't reply earlier, I was away for a few days. Wow, you all certainly are experts! And therefor way above my head ;-). Thanks for your input. A lot to think about. Allthough I did not completely understand it, the code from Static worked fine (I can see the description i...

That's exactly why i thought it should be possible to get the description of a queryfield in an actionquery in VBA: it ís possible to put in a description in the query grid (see attached picture). On the right you see the properties window ('Eigenschappenvenster' in Dutch). Right on top there is...

Thank you all for your replies. Looks like I have to live -;) with the fact that it is not possible to get the field description of action queries in vba

Dear Colin, Thanks for your reply. This was exactly what I was afraid of. I hoped there was another way I was not familiar with. Regards Ron

Thank you so much for your very quick reply, Jack. Unfortunately for tables as well as select queries, I already did almost exactly as you supposed. My problem is with action queries, where I am not able to loop through the fields collection, since it seems to be empty. Regards, Ron

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...

Hi to you all! I am Ron from the Netherlands and just joined the forum. I am familiar with the basics of Access and now ready to learn more! I also just started programming in VBA and need a lot of good advice. Sure I am on the right place for that! Look forward to meet you! Ron