Function??

[Judge Rein]

Access 2002 on desktop and notebook.
Same files on both computers

One has an error with a specific form while the other does
not. When copying file from computer which does fine to
the other, error reappears.

When copying file from computer with error to other, error
diappears.

Even reinstalled Access and of no help.

Problem: Simple form, simple table, -- about as easy
as basic as can be.

On form, Four(4)items are sums of various fields on the
form. On ONE computer and not on the other, the results
are "#Name$

Strange: When copying from working form on computer to
problem computer, the error appears as stated above.

Copying the same file back, the error disappears.

Other files also having "total" fields work well normally
on both computers.

All fileds on both computer obviously identical.

The formula with the problem is:
=nulltozero([amt1])+nulltozero([amt2])+nulltozero([amt3])
+nulltozero([amt4])+nulltozero([amt5])+nulltozero([amt6])
+nulltozero([amt7])

Please respond only to my email not to web site.
Thank you.

(e-mail address removed)

 

[Terry]

Check out the Nz() function. It will return zero or a
zero length string, depending on the context. The catch
is that the variable being operated on must be of variant
type.

-----Original Message-----
Hello Judge Rein,
Volunteers here do not generally send replies via email. Answers are posted
here so I hope you are reading this.

Nulltozero is not an intrinsic AccessVB function so there are two
possibilities:
a: You have defined this function in one of your modules -
If this were the case, then it would work on both computers
b. You are using an Access Add In or have a missing reference.
In the bad machine, open the Visual Basic Editor , click Tools >
References and see if you find any references are missing.
Copy the missing DLL or OCX file from good machine to bad machine and
remember to register it.

Hope that helps
HS

Access 2002 on desktop and notebook.
Same files on both computers

One has an error with a specific form while the other does
not. When copying file from computer which does fine to
the other, error reappears.

When copying file from computer with error to other, error
diappears.

Even reinstalled Access and of no help.

Problem: Simple form, simple table, -- about as easy
as basic as can be.

On form, Four(4)items are sums of various fields on the
form. On ONE computer and not on the other, the results
are "#Name$

Strange: When copying from working form on computer to
problem computer, the error appears as stated above.

Copying the same file back, the error disappears.

Other files also having "total" fields work well normally
on both computers.

All fileds on both computer obviously identical.

The formula with the problem is:
=nulltozero([amt1])+nulltozero([amt2])+nulltozero ([amt3])
+nulltozero([amt4])+nulltozero([amt5])+nulltozero ([amt6])
+nulltozero([amt7])

Please respond only to my email not to web site.
Thank you.

(e-mail address removed)

.