Problem with same file on one of two computers

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



Therefore I do not know if you can advise, and need to now
your fee.



Thank you.

 

[Douglas J. Steele]

Whenever you have a situation where a database works fine on one machine,
but not on another, the first thing to suspect is a problem with the
References.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

I have to wonder why you're using a custom function nulltozero, which sounds
as though it's the same as the built-in Nz function.

--
Doug Steele, Microsoft Access MVP

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)



Therefore I do not know if you can advise, and need to now
your fee.



Thank you.

 

[John Vinson]

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$

This appears to be the very common References bug. Open any
module in design view on the computer which is causing this
error, or open the VBA editor by typing Ctrl-G. Select Tools...
References from the menu. One of the .DLL files required by Access
will probably be marked MISSING. Uncheck it, recheck it, close and
open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

 

[Judge Rein]

Thank you.
No references were MISSING.
Did what you suggested; no help.
When looking for "refernces" on yhe functional computer
under tools - same way - references was grayed out and
could not open.
Now what?
HELP!!!

 

[Judge Rein]

Thank you.
No references were MISSING.
Did what you suggested; no help.
When looking for "refernces" on yhe functional computer
under tools - same way - references was grayed out and
could not open.
Now what?
HELP!!!

-----Original Message-----
Whenever you have a situation where a database works fine on one machine,
but not on another, the first thing to suspect is a problem with the
References.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

I have to wonder why you're using a custom function nulltozero, which sounds
as though it's the same as the built-in Nz function.

--
Doug Steele, Microsoft Access MVP

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)



Therefore I do not know if you can advise, and need to now
your fee.



Thank you.

.

 

[John Vinson]

Thank you.
No references were MISSING.

That's certainly consistant with the symptoms...

Did what you suggested; no help.
:-{(

When looking for "refernces" on yhe functional computer
under tools - same way - references was grayed out and
could not open.
Now what?
HELP!!!

Is this a .MDE file perchance? Which reference is marked MISSING -
possibly the application references an optional file which actually
*is* missing!