J
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)
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)