#Name? appears in a calculated form field in Access 2010.

Before the upgrade from 2007 it use to calculate the field properly. The OS in Win7. The same Access 2010 database on a WinXP machine calculates the field correctly. Are there any DLL's etc that are missing off the Win7 machine? I have re-installed Office 2010 about 5 times and no luck. Any registry keeys I need to look out for?
 

Question Info


Last updated September 7, 2018 Views 23,765 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Paul Sydney wrote:

Before the upgrade from 2007 it use to calculate the field properly.
The OS in Win7. The same Access 2010 database on a WinXP machine
calculates the field correctly. Are there any DLL's etc that are
missing off the Win7 machine? I have re-installed Office 2010 about 5
times and no luck. Any registry keeys I need to look out for?

I guess you are talking about the same db as in your next post
and maybe the same cause and cure.
Nevertheless you should paste in here the expression that you
use as control source.


cu
Karl
*******
Access-FAQ (German/Italian): http://www.donkarl.com

Karl
-----
Access Developers Conference: http://www.AccessDevCon.com
Acccess-Entwickler-Konferenz: http://www.donkarl.com/?AEK
Access FAQ (de/it): http://www.donkarl.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Karl, code which is in a text box on the same form is =[Departure date]-[Arrival date] and has worked fine for 5 years. This field works fine on a XP Machine using Access 2010.

Thanks

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Can you check that the text box name is NOT [Departure date] neither any other field name? Having the control of the same name as a field is not a problem, but here, the 'bouding' expression is not a field anymore, but an expression, and thus, a possible cyclic iteration can occur if there is a field of the same name, but possilby not with the same 'resulting' value.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Karl, there are actually 3 expressions on the form that all have #Name? error. One did have the same name as the text box, however the other 2 didn't. I have changed the one that did, saved the file, exit and restarted, but still no luck. Also to note, this exact Db on a WinXP machine, in Access 2010 works perfectly. I am thinking it's the error I'm getting re VBA & DLL registry. As I mentioned to Gina in another thread I have tried to re-install Win7 but after 3 hours it errored and stopped the re-install.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Paul,

Did you ever figure this out?  I now have this problem with some of my systems, but not others.  Haven't pinpointed the common link, but it was just after deploying a new version of the database front end.  So I had updated some forms and fields (minor stuff), but now other users are seeing these symptoms.  But not all machines.

Shawn

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I am seeing the same type of error in a report header. The header has a Date field [=Date()] and a separate time field [=time()] . The report runs fine on my machine (Win 7 Pro-32) but is getting the #name? error on a Win XP Machine.  I will check some other machines in the office and see if the error is repeated. We are both working off of the same database file as this is a server based dbase.

Any ideas.

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Just to let everyone know, I've upgraded all our users to 2010, the problem went away with no other changes to the database.  Definitely something Microsoft changed in an update that I apparently applied to my machine, then when I made some changes to the database, compiled and released a version, it broke it for everyone who was still on Office 2007.

Not a fix, just my solution.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I know this is an old thread but since I'm having the same issue I thought I'd post my troubleshooting.

 

I also get the #Name error, but only on EXISTING reports for databases that were created in earlier versions of Access. Even something simple like =[Page] textbox gives the error. However, I have successfully created a NEW report in the same database, and no errors.

 

My current work-around is to create a New report for every one of my existing reports, copy-&-paste all the controls and all the code, and delete the old report.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I had a #Name? in Access 2010 creating a form with a calculated field. I used the [table]![field] format and got the #Name? error. Removing the [table] using just he [field] cleared the error.

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I had a #Name? in Access 2010 creating a form with a calculated field. I used the [table]![field] format and got the #Name? error. Removing the [table] using just he [field] cleared the error.
Many thanks PitcherFamily. Just came in to the site with this problem and your solution of removing the Table Name worked for me (fresh install on new computer XP upgrade to Win 7 - generally very cranky but this solution worked right out the box!) . And it contradicts all the Manuals and Expression builders!! What else is new! Once again thanks.

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.