#NAME? error

[DrRein]

Access working fine until all forms in program that have a
formula beginning =nulltozero... are returning #NAME? in
the space instead of calculated amount.
Other computer fine. Copying good files from other
computer to this computer does not solve the problem.

Thank you.

 

[John Viescas]

What is nulltozero? A custom function in the application? Perhaps the
offending computer is missing a Visual Basic library required by the
application. If that's the case, the project becomes uncompiled, and you
get all sorts of strange errors when trying to reference both built-in and
user-defined functions. Open any module in Design view on the "bad"
computer. Choose References from the Tools menu. If that looks OK, try
choosing Compile from the Debug menu.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)