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 error
I am trying to put a total from a sub form onto another form but keep getting
the #name error message, any pointers would be most welcolm. I have a form named test table based on query, fields quantity, unit cost and total. In the footer of the form i have added text box which is named total unit cost. In the control source =sum([total]). This produces me with the correct results. I have created another form named link form which I have added a text box and input against the control source =([test table].Form.[total unit cost]. The only result I get is the #name when in form view. I have set these forms, tables up as a test, as I am experiencing the same problem on another database and hoped I could get it working on something as straight forward as this simple database. I am quite new to access, I have had this working on another database and cannot see what the difference is to idenftify where I am going wrong. |
#2
|
|||
|
|||
#Name error
#Name# is Access' way of telling you that spelling counts. Access can't
find the field and/or control the way you spelled it. Regards Jeff Boyce Microsoft Office/Access MVP "julief" wrote in message ... I am trying to put a total from a sub form onto another form but keep getting the #name error message, any pointers would be most welcolm. I have a form named test table based on query, fields quantity, unit cost and total. In the footer of the form i have added text box which is named total unit cost. In the control source =sum([total]). This produces me with the correct results. I have created another form named link form which I have added a text box and input against the control source =([test table].Form.[total unit cost]. The only result I get is the #name when in form view. I have set these forms, tables up as a test, as I am experiencing the same problem on another database and hoped I could get it working on something as straight forward as this simple database. I am quite new to access, I have had this working on another database and cannot see what the difference is to idenftify where I am going wrong. |
#3
|
|||
|
|||
#Name error
On Wed, 6 Aug 2008 07:50:02 -0700, julief
wrote: I am trying to put a total from a sub form onto another form but keep getting the #name error message, any pointers would be most welcolm. I have a form named test table based on query, fields quantity, unit cost and total. In the footer of the form i have added text box which is named total unit cost. In the control source =sum([total]). This produces me with the correct results. I have created another form named link form which I have added a text box and input against the control source =([test table].Form.[total unit cost]. The only result I get is the #name when in form view. I have set these forms, tables up as a test, as I am experiencing the same problem on another database and hoped I could get it working on something as straight forward as this simple database. I am quite new to access, I have had this working on another database and cannot see what the difference is to idenftify where I am going wrong. You need to reference the Forms collection. Try this instead: =Forms![test table]!Form.[total unit cost] Lynn Trapp www.ltcomputerdesigns.com |
#4
|
|||
|
|||
#Name error
I have tried your suggestion and it still produces the same result. I have
checked all the spellings and they are correct. "julief" wrote: I am trying to put a total from a sub form onto another form but keep getting the #name error message, any pointers would be most welcolm. I have a form named test table based on query, fields quantity, unit cost and total. In the footer of the form i have added text box which is named total unit cost. In the control source =sum([total]). This produces me with the correct results. I have created another form named link form which I have added a text box and input against the control source =([test table].Form.[total unit cost]. The only result I get is the #name when in form view. I have set these forms, tables up as a test, as I am experiencing the same problem on another database and hoped I could get it working on something as straight forward as this simple database. I am quite new to access, I have had this working on another database and cannot see what the difference is to idenftify where I am going wrong. |
#5
|
|||
|
|||
#Name error
I've only run across that when Access can't figure out what you're telling
it to use. Can you open that form in design view, open the properties window for that control, and pick the correct field from the listed fields? And if that doesn't work, what happens if you pick one of the other fields (incorrect, I know, but if you can see it displayed in the form, that tells us something...) Regards Jeff Boyce Microsoft Office/Access MVP "julief" wrote in message ... I have tried your suggestion and it still produces the same result. I have checked all the spellings and they are correct. "julief" wrote: I am trying to put a total from a sub form onto another form but keep getting the #name error message, any pointers would be most welcolm. I have a form named test table based on query, fields quantity, unit cost and total. In the footer of the form i have added text box which is named total unit cost. In the control source =sum([total]). This produces me with the correct results. I have created another form named link form which I have added a text box and input against the control source =([test table].Form.[total unit cost]. The only result I get is the #name when in form view. I have set these forms, tables up as a test, as I am experiencing the same problem on another database and hoped I could get it working on something as straight forward as this simple database. I am quite new to access, I have had this working on another database and cannot see what the difference is to idenftify where I am going wrong. |
#6
|
|||
|
|||
#Name error
I can see the control, if I pick it up I still get the #Name error, if i try
to pick something else up I get the #Error message. "Jeff Boyce" wrote: I've only run across that when Access can't figure out what you're telling it to use. Can you open that form in design view, open the properties window for that control, and pick the correct field from the listed fields? And if that doesn't work, what happens if you pick one of the other fields (incorrect, I know, but if you can see it displayed in the form, that tells us something...) Regards Jeff Boyce Microsoft Office/Access MVP "julief" wrote in message ... I have tried your suggestion and it still produces the same result. I have checked all the spellings and they are correct. "julief" wrote: I am trying to put a total from a sub form onto another form but keep getting the #name error message, any pointers would be most welcolm. I have a form named test table based on query, fields quantity, unit cost and total. In the footer of the form i have added text box which is named total unit cost. In the control source =sum([total]). This produces me with the correct results. I have created another form named link form which I have added a text box and input against the control source =([test table].Form.[total unit cost]. The only result I get is the #name when in form view. I have set these forms, tables up as a test, as I am experiencing the same problem on another database and hoped I could get it working on something as straight forward as this simple database. I am quite new to access, I have had this working on another database and cannot see what the difference is to idenftify where I am going wrong. |
#7
|
|||
|
|||
#Name error
Is your form "bound" to a query or a table?
If it is, and if it is the correct query/table, my next step, if this were mine, would be to start over building a new form from scratch. Or maybe one of the other newsgroup readers can offer a different perspective... Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "julief" wrote in message ... I can see the control, if I pick it up I still get the #Name error, if i try to pick something else up I get the #Error message. "Jeff Boyce" wrote: I've only run across that when Access can't figure out what you're telling it to use. Can you open that form in design view, open the properties window for that control, and pick the correct field from the listed fields? And if that doesn't work, what happens if you pick one of the other fields (incorrect, I know, but if you can see it displayed in the form, that tells us something...) Regards Jeff Boyce Microsoft Office/Access MVP "julief" wrote in message ... I have tried your suggestion and it still produces the same result. I have checked all the spellings and they are correct. "julief" wrote: I am trying to put a total from a sub form onto another form but keep getting the #name error message, any pointers would be most welcolm. I have a form named test table based on query, fields quantity, unit cost and total. In the footer of the form i have added text box which is named total unit cost. In the control source =sum([total]). This produces me with the correct results. I have created another form named link form which I have added a text box and input against the control source =([test table].Form.[total unit cost]. The only result I get is the #name when in form view. I have set these forms, tables up as a test, as I am experiencing the same problem on another database and hoped I could get it working on something as straight forward as this simple database. I am quite new to access, I have had this working on another database and cannot see what the difference is to idenftify where I am going wrong. |
Thread Tools | |
Display Modes | |
|
|