|
| 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
February 3rd, 2010, 04:04 PM
posted to microsoft.public.access.forms
|
|||
|
|||
#Name? in calculated fields
I have some pretty basic calc fields set up in a form. They were working just
fine. I went back into the same form and now the a #Name? error is showing up - yet I changed nothing? Any ideas on how a clac field would work fine then all of a sudden it doesn't work right? -- Message posted via http://www.accessmonster.com 
|
|
#2
February 3rd, 2010, 07:35 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? in calculated fields
#Name? means it can not find what it thinks is a field.
Maybe you changed something that it was refering to like a field of a cross tab query that now no longer exist. -- Build a little, test a little. "szag via AccessMonster.com" wrote: I have some pretty basic calc fields set up in a form. They were working just fine. I went back into the same form and now the a #Name? error is showing up - yet I changed nothing? Any ideas on how a clac field would work fine then all of a sudden it doesn't work right? -- Message posted via http://www.accessmonster.com .
|
|
#3
February 3rd, 2010, 09:40 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? in calculated fields
Hi -
You may get this error if the name of a control and the name of a control source are the same, e.g. if a control name is ProductCost and the name of a field in the underlying table/query is also ProductCost. If so, try changing the name of the control(s) to not match a field name. HTH John szag wrote: I have some pretty basic calc fields set up in a form. They were working just fine. I went back into the same form and now the a #Name? error is showing up - yet I changed nothing? Any ideas on how a clac field would work fine then all of a sudden it doesn't work right? -- John Goddard Ottawa, ON Canada jrgoddard at cyberus dot ca Message posted via http://www.accessmonster.com
|
|
#4
February 4th, 2010, 12:58 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? in calculated fields
It is likely a corrupted textbox. To test it, drag a new control onto the
form with the same controlsource. God Bless, Mark A. Sam "szag via AccessMonster.com" u2885@uwe wrote in message news:a3164c596344b@uwe... I have some pretty basic calc fields set up in a form. They were working just fine. I went back into the same form and now the a #Name? error is showing up - yet I changed nothing? Any ideas on how a clac field would work fine then all of a sudden it doesn't work right? -- Message posted via http://www.accessmonster.com
|
|
#5
February 4th, 2010, 02:59 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? in calculated fields
Thanks!
Mark A. Sam wrote: It is likely a corrupted textbox. To test it, drag a new control onto the form with the same controlsource. God Bless, Mark A. Sam I have some pretty basic calc fields set up in a form. They were working just [quoted text clipped - 3 lines] then all of a sudden it doesn't work right? -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
