Assign description to Query Object Properties (1 Viewer)

When you right-click on a query in the navigation pane, you can go about changing the query's object properties. How can you modify the same using VBA?

It's not a trivial task.
First you need to create the description property then set it to the value you want.
Whilst it can be done for SELECT queries, I'm not sure it's worth the effort.

Action queries are a different matter altogether.
See this thread https://www.access-programmers.co.uk/forums/showthread.php?t=299677

see https://www.tek-tips.com/viewthread.cfm?qid=616715

OOoops, I see Colin has responded also.

Thanks Jdraw,

Following the tektips link, this can this be done then by appending a new property to the query definition(?), and assigning the new description to it.
Presumably, I can update the new property as and when(?).

I'm writing a large number of SQL queries in VBA, on the basis of differing hospital patient types and varying date intervals, and assigning the SQL strings to a query, but I wanted to update the query "description" as well, so I can keep track in the navigation pane of which queries do what.

Must admit with my little knowledge, I thought it would still be a doddle.

No it's not a doddle as I mentioned previously.
Yes you can edit the property value as often as you like after its bee created.
However IMHO, It's one of those things where it's easier just to use the property sheet