Get MS Access Objects Description

[Kha]

Hi
How can I get or call MS Access Objects Description
By VBA and By Expression Builder?
Thanks
Picture Attached

 

[isladogs]

See my article

View Database Objects & Metadata

This article includes an example app used to view all objects in a database together with their properties and metadata.

www.isladogs.co.uk

 

[Kha]

See my article

View Database Objects & Metadata

This article includes an example app used to view all objects in a database together with their properties and metadata.

www.isladogs.co.uk

The article is excellent. I download your DB But I couldn't come up with a solution, because I am beginner user.
Can you post more hints her?
Please

 

[arnelgp]

if you put "description" to your Query (as in your image in post#1), then
it will be available, using:

Currentdb.QueryDefs("yourQueryName").Properties("Description")


but if you leave it blank, then the "Description" property does not exists
therefore you will get runtime error 3270.

 

[isladogs]

The article is excellent. I download your DB But I couldn't come up with a solution, because I am beginner user.
Can you post more hints her?
Please

To get this working in your own databases, you first need to copy all 6 objects listed in my article:
Forms - frmDatabaseObjects & frmObjMetadata
Report - rptDatabaseObjects
Tables - tblSysObjectTypes, tblObjMetadata
Module - modObjMetadata

If you want to keep my form footers, you also need to copy tblSettings & modFunctions - I will update the website article to mention that point later

Then open the form frmObjMetadata - & click Refresh Metadata to view the object descriptions for each item