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? in one of the reports
Hi folks
I have stumbled upon an issue and hopefully somebody has an idea. I have reports in my application and they seem to be fine on some computers running XP SP2 / Access 2003. On one of the computers, with the same configuration i.e. XPSP2/ Access 2003, 2 fields Full Name and Address always appear as #Name? The underlying query is fine and returns all the fields. The report concatenates the First name, Middle name and Last name into Full name and the same for Address. Why is that it displays OK on some computers and on that particular machine it always displays #Name? TIA Zul |
#2
|
|||
|
|||
#Name? in one of the reports
This is normally a symptom of using a field name as the name of a control.
For instance you have a text box: Name: [FirstName] Control Source: [FirstName] & " " & [LastName] I would find it hard to believe that any PC would not show the #Name error with the above properties. -- Duane Hookom MS Access MVP wrote in message oups.com... Hi folks I have stumbled upon an issue and hopefully somebody has an idea. I have reports in my application and they seem to be fine on some computers running XP SP2 / Access 2003. On one of the computers, with the same configuration i.e. XPSP2/ Access 2003, 2 fields Full Name and Address always appear as #Name? The underlying query is fine and returns all the fields. The report concatenates the First name, Middle name and Last name into Full name and the same for Address. Why is that it displays OK on some computers and on that particular machine it always displays #Name? TIA Zul |
#3
|
|||
|
|||
#Name? in one of the reports
Thanks very much for your prompt response.
However, this is not the case. My aggregate field names are definitely different than the constituent field name. Here is the sample code for Full Name Name = FullName Control Source = StrConv([MemberLastName],1) & [MemberMiddleName] & [MemberFirstName] Name=Address Control Source=[AccountStreetAddress] & [CityName] & [ProvinceAbbreviation] & [PostalCode] The thing that disturbs me is that why would it work on 2 machines perfectly, and not on this particular machine ? That is why I was leaning on a configuration issue. Any ideas ? Thanks for your help Zul Duane Hookom wrote: This is normally a symptom of using a field name as the name of a control. For instance you have a text box: Name: [FirstName] Control Source: [FirstName] & " " & [LastName] I would find it hard to believe that any PC would not show the #Name error with the above properties. -- Duane Hookom MS Access MVP wrote in message oups.com... Hi folks I have stumbled upon an issue and hopefully somebody has an idea. I have reports in my application and they seem to be fine on some computers running XP SP2 / Access 2003. On one of the computers, with the same configuration i.e. XPSP2/ Access 2003, 2 fields Full Name and Address always appear as #Name? The underlying query is fine and returns all the fields. The report concatenates the First name, Middle name and Last name into Full name and the same for Address. Why is that it displays OK on some computers and on that particular machine it always displays #Name? TIA Zul |
#4
|
|||
|
|||
#Name? in one of the reports
Any time an expression works on one computer and not another, you should
check the references on the non-working PC. Consider reviewing Doug Steele's page on Access Reference Problems http://www.accessmvp.com/djsteele/Ac...nceErrors.html. -- Duane Hookom MS Access MVP wrote in message oups.com... Thanks very much for your prompt response. However, this is not the case. My aggregate field names are definitely different than the constituent field name. Here is the sample code for Full Name Name = FullName Control Source = StrConv([MemberLastName],1) & [MemberMiddleName] & [MemberFirstName] Name=Address Control Source=[AccountStreetAddress] & [CityName] & [ProvinceAbbreviation] & [PostalCode] The thing that disturbs me is that why would it work on 2 machines perfectly, and not on this particular machine ? That is why I was leaning on a configuration issue. Any ideas ? Thanks for your help Zul Duane Hookom wrote: This is normally a symptom of using a field name as the name of a control. For instance you have a text box: Name: [FirstName] Control Source: [FirstName] & " " & [LastName] I would find it hard to believe that any PC would not show the #Name error with the above properties. -- Duane Hookom MS Access MVP wrote in message oups.com... Hi folks I have stumbled upon an issue and hopefully somebody has an idea. I have reports in my application and they seem to be fine on some computers running XP SP2 / Access 2003. On one of the computers, with the same configuration i.e. XPSP2/ Access 2003, 2 fields Full Name and Address always appear as #Name? The underlying query is fine and returns all the fields. The report concatenates the First name, Middle name and Last name into Full name and the same for Address. Why is that it displays OK on some computers and on that particular machine it always displays #Name? TIA Zul |
Thread Tools | |
Display Modes | |
|
|