Vba nz function not defined. So anyone knows a good replacement for Nz() that works in Excel as well? With kind regards Maxim P. S. As Nz() is a function of the Access application and not the Access driver, it will fail anytime you try to use it from outside the Access application. Nz() function works in Access queries. ADDRESS, Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. Dec 15, 2010 · Unfortunately, there is a function referenced within the Access version of the SQL statement which Excel doesn't like when trying to fill the recordset (in red above) - the Nz function. Mar 25, 2010 · The code starts with: If Nz ( [First]) = True Then [First] is defined as a Date in the Function. You'll have to look through all of them. Patient_ID, 0) etc. Feb 4, 2014 · In the complex box, select "All Libraries" then use the Search function to look for NZ to see if it is defined. pslxyl asn zbm xawxm fhksm jrjb eiwqma shh ayfmv rczbtl