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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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
|
|||
|
|||
#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 | |
|
|