|
| 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
October 3rd, 2006, 11:56 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Calculations in "unbound" boxes
I have a form that is linked to a table. I created an "unbound" text box on
my form. I am using the expression builder to build simple calculations (field1/field2). However, my form displays "#NAME?" Any ideas? 
|
|
#2
October 4th, 2006, 12:10 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculations in "unbound" boxes
Hum, what does the source of the text box look like?
Normally, you need to build a expression like =([Field1] / [field2]) Try the above..... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada
|
|
#3
October 4th, 2006, 12:16 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculations in "unbound" boxes
On Tue, 3 Oct 2006 15:56:02 -0700, Rob
wrote: I have a form that is linked to a table. I created an "unbound" text box on my form. I am using the expression builder to build simple calculations (field1/field2). However, my form displays "#NAME?" Any ideas? Put an equals sign in front of it. Set the control source of the expression textbox to =[field1] / [field2] Do use the square brackets, otherwise it will try to divide the text string "field1" by the text string "field2" and get REALLY confused! John W. Vinson[MVP]
|
|
#4
October 4th, 2006, 12:32 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculations in "unbound" boxes
Ok, I tried it but I am still receiving the error. Any other ideas?
"John Vinson" wrote: On Tue, 3 Oct 2006 15:56:02 -0700, Rob wrote: I have a form that is linked to a table. I created an "unbound" text box on my form. I am using the expression builder to build simple calculations (field1/field2). However, my form displays "#NAME?" Any ideas? Put an equals sign in front of it. Set the control source of the expression textbox to =[field1] / [field2] Do use the square brackets, otherwise it will try to divide the text string "field1" by the text string "field2" and get REALLY confused! John W. Vinson[MVP]
|
|
#5
October 4th, 2006, 12:45 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculations in "unbound" boxes
On Tue, 3 Oct 2006 16:32:01 -0700, Rob
wrote: Ok, I tried it but I am still receiving the error. Any other ideas? No, because I cannot see your database; do not know the names of the fields in your table; do not know the nature of the Recordsource for your form; and do not know what you actually have as the expression. Could you please give us a little help here? John W. Vinson[MVP]
|
|
#6
October 4th, 2006, 12:57 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculations in "unbound" boxes
Is the name of the text box the same as a field in the table? That can
sometimes cause #NAME, in fact if [field1] or [field2] is the name of a form control and also the name of a table field in the form's source, you may get this. John Rob wrote: Ok, I tried it but I am still receiving the error. Any other ideas? "John Vinson" wrote: On Tue, 3 Oct 2006 15:56:02 -0700, Rob wrote: I have a form that is linked to a table. I created an "unbound" text box on my form. I am using the expression builder to build simple calculations (field1/field2). However, my form displays "#NAME?" Any ideas? Put an equals sign in front of it. Set the control source of the expression textbox to =[field1] / [field2] Do use the square brackets, otherwise it will try to divide the text string "field1" by the text string "field2" and get REALLY confused! John W. Vinson[MVP]
|
|
#7
October 4th, 2006, 01:07 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculations in "unbound" boxes
Ok.
The table name is Kent, which the form is pointed to. My expression is "= [Kent]![Volumes] / [Kent]![Labor Hours] " I am using an unbound text box named "text 453" Thanks. "John Vinson" wrote: On Tue, 3 Oct 2006 16:32:01 -0700, Rob wrote: Ok, I tried it but I am still receiving the error. Any other ideas? No, because I cannot see your database; do not know the names of the fields in your table; do not know the nature of the Recordsource for your form; and do not know what you actually have as the expression. Could you please give us a little help here? John W. Vinson[MVP]
|
|
#8
October 4th, 2006, 01:16 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Calculations in "unbound" boxes
On Tue, 3 Oct 2006 17:07:02 -0700, Rob
wrote: Ok. The table name is Kent, which the form is pointed to. My expression is "= [Kent]![Volumes] / [Kent]![Labor Hours] " I am using an unbound text box named "text 453" Leave off the tablename and the !. John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
