#Name? error on selected machines

[Peter Monica]

Hey there,
I have an mde in A97 that works fine on my machine, but
won't work on others. The database will open on the other
machines, but certain code in reports causes #Name? to
appear instead of the calculated value that should. Other
data (not calculated, but queried) on the reports appears
fine. All machines are W2K running A97 SR2 with SR1
installed, then upgraded to SR2. Has anyone experienced
this before?

As always,
Thanks.

 

[fredg]

Hey there,
I have an mde in A97 that works fine on my machine, but
won't work on others. The database will open on the other
machines, but certain code in reports causes #Name? to
appear instead of the calculated value that should. Other
data (not calculated, but queried) on the reports appears
fine. All machines are W2K running A97 SR2 with SR1
installed, then upgraded to SR2. Has anyone experienced
this before?

As always,
Thanks.

Search Access Help:
Error + Troubleshoot controls +
#Error? or #Name? appears in a control.

 

[Andy]

I have seen this on my databases too. I was able to correct it by fixing
Missing References on the target machine.

hth,
Andy

 

[Peter Monica]

You are correct, sort of. I had a reference to Word 9.0
(2000) on my machine, but user had 8.0 (97) installed on
his. Thanks for the help!