#Name? in one of the reports

[zkheraj]

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

 

[Duane Hookom]

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.

 

[zkheraj]

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

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

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

 

[Duane Hookom]

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/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

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

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

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