Why do I get the Total price saying #Name? afte the calculation?

[Pepe]

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view. Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

 

[Tom Lake]

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[Pepe]

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[Pepe]

Hi! Karl, I am sorry I did not realize there was another post for me until
now. Thank you very much for trying to help me. I was doing Microsoft
access 2003 training page which is
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178821033&ReturnFromPractHelp=1.
I have tried many times but still total price come out #Name?. I follow
the instruction very carefully.
I am so puzzled why I get this. Do you have any suggestion?
I am sorry for taking your precious time for me.
Thank you so much for your kindness.
--
Pepe

What is the name of the field you are summing?

Post your SQL / Control Source information.

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[KARL DEWEY]

You normally get #Name? when Access does not recognize the data source
as valid. Double check spelling, punctuation, to include number of spaces in
field names.

Post the Control Source statement for the text box.

Hi! Karl, I am sorry I did not realize there was another post for me until
now. Thank you very much for trying to help me. I was doing Microsoft
access 2003 training page which is
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178821033&ReturnFromPractHelp=1.
I have tried many times but still total price come out #Name?. I follow
the instruction very carefully.
I am so puzzled why I get this. Do you have any suggestion?
I am sorry for taking your precious time for me.
Thank you so much for your kindness.
--
Pepe

What is the name of the field you are summing?

Post your SQL / Control Source information.

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe


:

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[Pepe]

Thank you so much for your reply again.
I put =Sum([UnitPrice]*[Quantity]) in the control source box of subform and
=[Order Details].Form!Total in the main form.
I just wonder it is something to do with my computer which has English and
Japanese language setting.
Kind regards,
Pepe

You normally get #Name? when Access does not recognize the data source
as valid. Double check spelling, punctuation, to include number of spaces in
field names.

Post the Control Source statement for the text box.

Hi! Karl, I am sorry I did not realize there was another post for me until
now. Thank you very much for trying to help me. I was doing Microsoft
access 2003 training page which is
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178821033&ReturnFromPractHelp=1.
I have tried many times but still total price come out #Name?. I follow
the instruction very carefully.
I am so puzzled why I get this. Do you have any suggestion?
I am sorry for taking your precious time for me.
Thank you so much for your kindness.
--
Pepe

What is the name of the field you are summing?

Post your SQL / Control Source information.

:

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe


:

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[KARL DEWEY]

Which text box is displaying the #Name? -- is it the main form or subform?

Thank you so much for your reply again.
I put =Sum([UnitPrice]*[Quantity]) in the control source box of subform and
=[Order Details].Form!Total in the main form.
I just wonder it is something to do with my computer which has English and
Japanese language setting.
Kind regards,
Pepe

You normally get #Name? when Access does not recognize the data source
as valid. Double check spelling, punctuation, to include number of spaces in
field names.

Post the Control Source statement for the text box.

Hi! Karl, I am sorry I did not realize there was another post for me until
now. Thank you very much for trying to help me. I was doing Microsoft
access 2003 training page which is
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178821033&ReturnFromPractHelp=1.
I have tried many times but still total price come out #Name?. I follow
the instruction very carefully.
I am so puzzled why I get this. Do you have any suggestion?
I am sorry for taking your precious time for me.
Thank you so much for your kindness.
--
Pepe


:

What is the name of the field you are summing?

Post your SQL / Control Source information.

:

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe


:

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[Pepe]

Hi!,Karl,
I am sorry for my dalayed answer. The answer is in the main form.
Thank you very much for trying to help me.


--
Pepe

Which text box is displaying the #Name? -- is it the main form or subform?

Thank you so much for your reply again.
I put =Sum([UnitPrice]*[Quantity]) in the control source box of subform and
=[Order Details].Form!Total in the main form.
I just wonder it is something to do with my computer which has English and
Japanese language setting.
Kind regards,
Pepe

You normally get #Name? when Access does not recognize the data source
as valid. Double check spelling, punctuation, to include number of spaces in
field names.

Post the Control Source statement for the text box.

:

Hi! Karl, I am sorry I did not realize there was another post for me until
now. Thank you very much for trying to help me. I was doing Microsoft
access 2003 training page which is
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178821033&ReturnFromPractHelp=1.
I have tried many times but still total price come out #Name?. I follow
the instruction very carefully.
I am so puzzled why I get this. Do you have any suggestion?
I am sorry for taking your precious time for me.
Thank you so much for your kindness.
--
Pepe


:

What is the name of the field you are summing?

Post your SQL / Control Source information.

:

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe


:

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[KARL DEWEY]

It appears that a control (Total ) on the subform ([Order Details]) is being
reference on the main form.

If this is the case then you nee to reference it this way ---
[Forms]![MainFormName]![SubFormName]![ControlName]

It seems like it would be something like this --
[Forms]![MainFormName]![Order Details]![Total]

Did you ever resolve your issue? I'm getting the same error and having a
heck of a time figuring out what's going on. I created a database in Access
07 and then converted it to Access 03. When I open the file in Access 03 I
get the error. I don't get the same error in the file when I use Access 07.

Thanks,
DJ

Hi!,Karl,
I am sorry for my dalayed answer. The answer is in the main form.
Thank you very much for trying to help me.


--
Pepe

Which text box is displaying the #Name? -- is it the main form or subform?

:

Thank you so much for your reply again.
I put =Sum([UnitPrice]*[Quantity]) in the control source box of subform and
=[Order Details].Form!Total in the main form.
I just wonder it is something to do with my computer which has English and
Japanese language setting.
Kind regards,
Pepe


:

You normally get #Name? when Access does not recognize the data source
as valid. Double check spelling, punctuation, to include number of spaces in
field names.

Post the Control Source statement for the text box.

:

Hi! Karl, I am sorry I did not realize there was another post for me until
now. Thank you very much for trying to help me. I was doing Microsoft
access 2003 training page which is
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178821033&ReturnFromPractHelp=1.
I have tried many times but still total price come out #Name?. I follow
the instruction very carefully.
I am so puzzled why I get this. Do you have any suggestion?
I am sorry for taking your precious time for me.
Thank you so much for your kindness.
--
Pepe


:

What is the name of the field you are summing?

Post your SQL / Control Source information.

:

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe


:

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake

 

[DJ Boise]

Thanks for the reply Karl.

Here's what I'm having issues with:
=[Forms]![Collection Invoice]![Fees Collected Subform].[Form]![FeeSum]

What I don't understand is that I built the database using Access 07.
Coverted the file to Access 2003 because that's what's installed on the
computers that will access the database. When I open the coverted file in
Access 07 everything works fine. However when I open the file in Access 03 I
get the #Name? error. Thoughts?

Thanks,
DJ

It appears that a control (Total ) on the subform ([Order Details]) is being
reference on the main form.

If this is the case then you nee to reference it this way ---
[Forms]![MainFormName]![SubFormName]![ControlName]

It seems like it would be something like this --
[Forms]![MainFormName]![Order Details]![Total]

Did you ever resolve your issue? I'm getting the same error and having a
heck of a time figuring out what's going on. I created a database in Access
07 and then converted it to Access 03. When I open the file in Access 03 I
get the error. I don't get the same error in the file when I use Access 07.

Thanks,
DJ

Hi!,Karl,
I am sorry for my dalayed answer. The answer is in the main form.
Thank you very much for trying to help me.


--
Pepe


:

Which text box is displaying the #Name? -- is it the main form or subform?

:

Thank you so much for your reply again.
I put =Sum([UnitPrice]*[Quantity]) in the control source box of subform and
=[Order Details].Form!Total in the main form.
I just wonder it is something to do with my computer which has English and
Japanese language setting.
Kind regards,
Pepe


:

You normally get #Name? when Access does not recognize the data source
as valid. Double check spelling, punctuation, to include number of spaces in
field names.

Post the Control Source statement for the text box.

:

Hi! Karl, I am sorry I did not realize there was another post for me until
now. Thank you very much for trying to help me. I was doing Microsoft
access 2003 training page which is
http://office.microsoft.com/training/Training.aspx?AssetID=RP101178821033&ReturnFromPractHelp=1.
I have tried many times but still total price come out #Name?. I follow
the instruction very carefully.
I am so puzzled why I get this. Do you have any suggestion?
I am sorry for taking your precious time for me.
Thank you so much for your kindness.
--
Pepe


:

What is the name of the field you are summing?

Post your SQL / Control Source information.

:

Thank you very much for writing me a suggestion. But I don't think I was
doing that.
It's very difficult to explain here what I've done. I just wonder anybody
else had same experience with different reason.
I am very much appreciated for your advice.
Thank you.
--
Pepe


:

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.
Did
anybody experienced this.
I thought I was doing exactly the way the instruction says.
Thank you

One cause of that error is when you name the text box the same as the field
you're summing. Example: If the field you're summing is Total and the
calculation
is =Sum([Total]) then the text box can't be named Total.

Tom Lake