QueryDef Description property RRS feed

  • Question

  • I am using Access 2010 and I noticed an odd behavior accessing QueryDefs().Properties("Description").  If a query Q references only a single table and does not have a description of property of its own, DBEngine(0)(0)QueryDefs("Q").Properties("Description") will return the description property of the single underlying table rather than erroring out, which it should do.  Anyone else notice this odd behavior, or is it just me?

    I posted an example at!AukpdoLbHDipij4h4A66FSkn65aq?e=lcABNv

    Open qdf.accdb and enter


    in the Immediate window.


    Thursday, June 13, 2019 8:13 PM

All replies