Suddenly getting #Name?

[Flopbot]

Hi,

I know this will probably be obvious. I changed the names of all my forms,
subforms, and queries to something a little more standard. Up to that point,
one of my control boxes worked perfectly but has since stopped working and I
get the error message: #Name? Basically, the control is supposed to add
together two subtotals located on the form footer section of my subform. I
have triple checked the names and format of the following equation and
everything looks perfect to me. I’ve also checked links and every properties
box I can find. Is there something I’m missing or does Access ‘03 not like
my choice of names?


New Equation (doesn’t work):

=Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form!Subtotal))+Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form![Subtotal Other Hours]))


Old Equation (worked):

=Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form!Subtotal))+Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form![Subtotal Other Hours]))

 

[Bob Quintal]

Hi,

I know this will probably be obvious. I changed the names of all
my forms, subforms, and queries to something a little more
standard. Up to that point, one of my control boxes worked
perfectly but has since stopped working and I get the error
message: #Name? Basically, the control is supposed to add
together two subtotals located on the form footer section of my
subform. I have triple checked the names and format of the
following equation and everything looks perfect to me. I’ve
also checked links and every properties box I can find. Is there
something I’m missing or does Access ‘03 not like my choice of
names?


New Equation (doesn’t work):

=Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form!Subtotal))+Nz((Forms![Frm Volunteer Database]![SubFrm
Vol Hours].Form![Subtotal Other Hours]))


Old Equation (worked):

=Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form!Subtotal))+Nz((Forms![Volunteer Database
Frm]![Volunteer Hours Subform].Form![Subtotal Other Hours]))

You probably forgot to change the name of the subform control on hte
main form, and/or the Source Object of the subform control.

 

[Tom Wickerath]

Hi Flopbot,

I agree with Bob Quintal's reply "You probably forgot to change the name of
the subform control on the main form, and/or the Source Object of the subform
control."

Take a look at Figure 5 in this article:
http://www.access.qbuilt.com/html/subtotals.html

It shows an example of learning the name of the subform container control.
Also, here is a KB article that you may find helpful (ignore the "ACC2000" in
the title, as this article applies to all versions of Access):

Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132

Finally, I have to ask, if you took the time to rename objects (or example,
"Volunteer Database Frm" to "Frm Volunteer Database"), why didn't you
eliminate the spaces in the name at the same time, ie. frmVolunteerDatabase?

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Also, make sure that you are not using any reserved words:

Problem names and reserved words in Access
http://allenbrowne.com/AppIssueBadWord.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Flopbot]

Thank you both! That was. . ."obscure", to say the least. It ended up being
exactly like you said. The name on the Subform properties ended up being
labeled using the old name. Works like a charm now! Thanks!

Hi Flopbot,

I agree with Bob Quintal's reply "You probably forgot to change the name of
the subform control on the main form, and/or the Source Object of the subform
control."

Take a look at Figure 5 in this article:
http://www.access.qbuilt.com/html/subtotals.html

It shows an example of learning the name of the subform container control.
Also, here is a KB article that you may find helpful (ignore the "ACC2000" in
the title, as this article applies to all versions of Access):

Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132

Finally, I have to ask, if you took the time to rename objects (or example,
"Volunteer Database Frm" to "Frm Volunteer Database"), why didn't you
eliminate the spaces in the name at the same time, ie. frmVolunteerDatabase?

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Also, make sure that you are not using any reserved words:

Problem names and reserved words in Access
http://allenbrowne.com/AppIssueBadWord.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

Hi,

I know this will probably be obvious. I changed the names of all my forms,
subforms, and queries to something a little more standard. Up to that point,
one of my control boxes worked perfectly but has since stopped working and I
get the error message: #Name? Basically, the control is supposed to add
together two subtotals located on the form footer section of my subform. I
have triple checked the names and format of the following equation and
everything looks perfect to me. I’ve also checked links and every properties
box I can find. Is there something I’m missing or does Access ‘03 not like
my choice of names?


New Equation (doesn’t work):

=Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form!Subtotal))+Nz((Forms![Frm Volunteer Database]![SubFrm Vol
Hours].Form![Subtotal Other Hours]))


Old Equation (worked):

=Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form!Subtotal))+Nz((Forms![Volunteer Database Frm]![Volunteer Hours
Subform].Form![Subtotal Other Hours]))

 

[Tom Wickerath]

Glad to read of your success!
You're very welcome.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________