#Name?

  • Thread starter Thread starter DrRein
  • Start date Start date
D

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.
 
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.
Click to expand...

The name of the builtin function is NZ(), not nulltozero. What version
of Access? Do the working computers have a custom function of that
name? If you Compact the database, open the vba editor and select
Debug... Compile <project> (or Debug... Compile and Save All Modules
for A97 and before) do you see any code errors?
 
Back
Top