none
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 https://1drv.ms/u/s!AukpdoLbHDipij4h4A66FSkn65aq?e=lcABNv

    Open qdf.accdb and enter

    ?dbengine(0)(0).QueryDefs("MyQuery").Properties("Description")

    in the Immediate window.

    -Bruce

    Thursday, June 13, 2019 8:13 PM

All replies