#Name? showing up in reports__

L

Lynn Pennington

Hi.
I have a Access 2000 database with linked tables to SQL
2000. Users that have Access 2000 and XP the reports are
okay. The users what have Access 2003 is
displays "#Name?". This is is a calulated field.
Any ideas.
Thanks.
Lynn.
 
D

Dirk Goldgar

Lynn Pennington said:
Hi.
I have a Access 2000 database with linked tables to SQL
2000. Users that have Access 2000 and XP the reports are
okay. The users what have Access 2003 is
displays "#Name?". This is is a calulated field.
Any ideas.
Thanks.
Lynn.
Click to expand...

Check for broken references on the A2003 computers. Often when
databases don't work on one particular machine, it's because of a broken
or missing reference. See if the steps outlined here help:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
W

Wayne Morgan

Since it works on one computer but not another, Dirk is probably correct.
The other thing that can cause this is the field and control both having the
same name, causing a "circular reference". However, if that was the case, I
wouldn't expect it to work on any computer.
 
L

Lynn Pennington

Thank You.
I will review this article.
Lynn.

-----Original Message-----
message news:[email protected]

Check for broken references on the A2003 computers. Often when
databases don't work on one particular machine, it's because of a broken
or missing reference. See if the steps outlined here help:
Errors.html

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.
Click to expand...
 
Top