Error 3085: Undefined functions 'Nz' in expression
Posted on 2008-06-16
I have developed an application in Access 2003. It quite large an in the final stages of development. The application is to be distributed with the SageKeys Access 2003 MSI wizard (which is very good). The install works perfect but I have discovered that when installed on to a Microsoft Vista Machine the application throws the error: Error 3085 - Undefined functions'Nz' in expression.
I use the Nz function extensively throughout the program. In queries, forms, reports and modules. On the vista machine the program does not crash, but nothing displays on the forms because of this error.
1. Does anyone know why the Nz funciton is not found on the installation?
2. Can I fix it without recoding every occurance to iif and isnull statements?