#Name? error in existing Reports

[Guest]

I have just upgraded my PC and now most access reports show the #Name? error
for multiple bound fields. The reports work just fine on all other PCs in
the office. My old system was XP Pro sp2 and Access 2000, as is the new
system. I have uninstalled access and reinstalled it. I cannot seem to get
rid of the problem. If I unbind the field in the report and rebind it
without parameters like "TRIM" the data will display correctly except for
formatting of course.

This has me stumped as it seams to be PC related, not Application related.
is there possible a dll that is not registering correctly on my system? Any
help would be appreciated. By the way I do plan to upgrade all the PCs in my
office to Office 2006 when it is released this spring.

 

[Allen Browne]

You may have a bad reference.
Press Ctrl+G to open the Immediate Window.
Then choose References from the Tools menu.
Are any of the checked libraries marked "MISSING"?
If so see:
http://allenbrowne.com/ser-38.html
for instructions on how to re-register them or remove the libraries you
don't need in your version of Access.

If that is not the issue, it could be related to the printer. Access uses
the printer metrics to calculate the layout of the report. If there is no
printer installed, or if the printer driver is faulty, you can also get the
symptoms you describe. Installing a valid printer should solve the problem.
You can see what printer Access 2002 is trying to use and how many it can
see by opening the Immediate Window (Ctrl+G) and entering:
? Printer.DeviceName
? Printers.Count

 

[Guest]

Allen,

You were right, I had a missing reference. This happened about 2 years ago,
and upon reserching I about missing references and fixed it then. The
problem was familiar to me, I just could not pull the conection out of my
mind to references this time.

Thanks for jogging my memory. You were a big help

Steve

You may have a bad reference.
Press Ctrl+G to open the Immediate Window.
Then choose References from the Tools menu.
Are any of the checked libraries marked "MISSING"?
If so see:
http://allenbrowne.com/ser-38.html
for instructions on how to re-register them or remove the libraries you
don't need in your version of Access.

If that is not the issue, it could be related to the printer. Access uses
the printer metrics to calculate the layout of the report. If there is no
printer installed, or if the printer driver is faulty, you can also get the
symptoms you describe. Installing a valid printer should solve the problem.
You can see what printer Access 2002 is trying to use and how many it can
see by opening the Immediate Window (Ctrl+G) and entering:
? Printer.DeviceName
? Printers.Count