A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

#Name? displayed in some fields



 
 
Thread Tools Display Modes
  #1  
Old December 7th, 2007, 04:10 AM posted to microsoft.public.access.reports
Steve Mackey
external usenet poster
 
Posts: 1
Default #Name? displayed in some fields

I have an Access report in a database on a network drive being accessed by
several computers running Access 2003. When the report is run from some PCs,
the data displays normally on the report. However, when run from other PCs,
the same report (accessing the same data records) displays #Name? in some
fields on the report. Is there some external file, perhaps a .DLL file, or
setting that would cause this to happen?
  #2  
Old December 7th, 2007, 06:09 AM posted to microsoft.public.access.reports
Allen Browne
external usenet poster
 
Posts: 11,706
Default #Name? displayed in some fields

The trick will be to see what's different between the computers where it
works, and those where it doesn't.

It could be due to a bad reference:
http://allenbrowne.com/ser-38.html

It could be due to a difference in versions. Compare the version of
msaccess.exe (in the folder where Office is installed) or msjet40.dll (in
Windows\System32), by finding the file in MyComputer, right-clicking and
choosing Version. If you need an update in either, go to:
support.microsoft.com/sp
and get the Office service pack, or the JET service pack.
More info about getting the version info programmatically:
http://allenbrowne.com/ser-53.html

#Name can also be due to a badly named control, e.g. a control that has the
same name as a field, but is bound to something else. #Error can also occur
when a user filters a report such that no records match.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve Mackey" Steve wrote in message
...
I have an Access report in a database on a network drive being accessed by
several computers running Access 2003. When the report is run from some
PCs,
the data displays normally on the report. However, when run from other
PCs,
the same report (accessing the same data records) displays #Name? in some
fields on the report. Is there some external file, perhaps a .DLL file, or
setting that would cause this to happen?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.