#Name? in calculated fields
in [Form]
|
From: szag via AccessMonster.com on 3 Feb 2010 11:04 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
From: KARL DEWEY on 3 Feb 2010 14:35 #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 > > . >
From: J_Goddard via AccessMonster.com on 3 Feb 2010 16:40 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
From: Mark A. Sam on 4 Feb 2010 07:58 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(a)uwe> wrote in message news:a3164c596344b(a)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 >
From: szag via AccessMonster.com on 4 Feb 2010 09:59 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
|
Pages: 1 Prev: How To Access From VBA A Tables Row Lookup Row Source Next: Change Text Box to Check Box |