I am trying to obtain the descriptive text I entered against the queries I have developed, as I want these to appear in documentation. This text doesn't appear in the the output from the database documenter.
The particular line to retrieve this information (and write it into a table specifically for the name, SQL and Description) is:
rstList!Description = CurrentDb.QueryDefs(i).Properties.["Description"]
When commented out the code produces results (although there does appear to be some clean up to be done)
When included to results in : Compile Error: Method or data member not found".
I have tried various changes to the way in which Description is referenced but to no avail - what is the correct syntax to obtain the description?
And btw:
this line
rstList!QueryName = CurrentDb.QueryDefs(i).Name
produces records that have the structure: ~sq_cfNonMbrPerson~sq_cfrmMember2sub
as well as records for the regular queries. Presumably arising from forms/ subforms using the query
Thanks for any assistance
The particular line to retrieve this information (and write it into a table specifically for the name, SQL and Description) is:
rstList!Description = CurrentDb.QueryDefs(i).Properties.["Description"]
When commented out the code produces results (although there does appear to be some clean up to be done)
When included to results in : Compile Error: Method or data member not found".
I have tried various changes to the way in which Description is referenced but to no avail - what is the correct syntax to obtain the description?
And btw:
this line
rstList!QueryName = CurrentDb.QueryDefs(i).Name
produces records that have the structure: ~sq_cfNonMbrPerson~sq_cfrmMember2sub
as well as records for the regular queries. Presumably arising from forms/ subforms using the query
Thanks for any assistance