Recent content by Rob_B

FYI - Solved it. Proper syntax is: intTestEmpty = appAccess.Nz(appAccess.DCount(strQField, strOpenQuery), 0) The function's effective domain needs to be consistent - in my usage the Nz function was within the CurrentDb and DCount was acting in the Access application that I was referring to...

Tried that. It gives me the "Run-time error 3078: Can't find input table or query, blah blah." Which led me to believe that the DCount function was executing within the calling instance of Access and not the target, hence the use of the appAccess. hoping it would call the function within that...

I'm having a syntax issue with using DCount to test the results of a query in an external database. I get the "Run-time Error 2001: You cancelled the previous operation." In a nutshell the module runs 70 queries in 40 databases by looping a recordset that has the queries and databases. If the...