Concatenation Error in Access 2000 report

I created an access journal entry program many years ago. It works
for all and was working for an individual until recently. The report
shows ?Name! for every instance it repeats in the report. The field
in the report is a text box: named Text12. Bad coding I know. The
concat goes like this...

=Str([ToCompany]) & "-" & [AcctUnit] & "-" & [Account] & "-" &
[SubAcct]

ToCompany is a number. Like I said it works for all others but one
person. I wonder if there is a PC dll issue. I would love any help
you can provide.

Chris

re: Concatenation Error in Access 2000 report

On 1 Jul 2004 07:45:06 -0700, MT 2MB wrote:
[color=blue]
> I created an access journal entry program many years ago. It works
> for all and was working for an individual until recently. The report
> shows ?Name! for every instance it repeats in the report. The field
> in the report is a text box: named Text12. Bad coding I know. The
> concat goes like this...
>
> =Str([ToCompany]) & "-" & [AcctUnit] & "-" & [Account] & "-" &
> [SubAcct]
>
> ToCompany is a number. Like I said it works for all others but one
> person. I wonder if there is a PC dll issue. I would love any help
> you can provide.
>
> Chris[/color]

Chris,
Several possibilities.
1) The computer has a missing reference. *
See below...
2) You don't need to convert the number to a string Str() when
concatenating it.
Try:
=[ToCompany] & "-" & [AcctUnit] & etc.

3) I've found the the #Name error is usually due to Access not being
able to find a field (miss-spelling?) in the expression, i.e.
[ToCompany] instead of [To Company]. Check the spelling.

4) re: The field in the report is a text box: named Text12.
I hope you mean the control name in the report.

* To resolve a Missing reference:
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.

For even more information, see:
http://members.rogers.com/douglas.j....nceErrors.html

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

re: Concatenation Error in Access 2000 report

Can you verify that the underlying query hasn't changed? Sometimes, a
query "magically" changes, dropping one or more important fields (is
there such a thing as an unimportant field? Oh, yes, one named
"Text12" - just kidding :-)

Anyway, the general idea is to "walk backwards" until you trace the
problem.

Hope this helps.

cridings@usatoday.com (MT 2MB) wrote in message news:<f0b569b6.0407010645.1b4483a0@posting.google. com>...[color=blue]
> I created an access journal entry program many years ago. It works
> for all and was working for an individual until recently. The report
> shows ?Name! for every instance it repeats in the report. The field
> in the report is a text box: named Text12. Bad coding I know. The
> concat goes like this...
>
> =Str([ToCompany]) & "-" & [AcctUnit] & "-" & [Account] & "-" &
> [SubAcct]
>
> ToCompany is a number. Like I said it works for all others but one
> person. I wonder if there is a PC dll issue. I would love any help
> you can provide.
>
> Chris[/color]

re: Concatenation Error in Access 2000 report

My thinking would be:

Either

The function str(), not a function I'm vary familiar with, is perhaps
a function that is not in one of the reference libraries on that
person's machine.

To check this make sure that the reference libraries (and order) are
the same as one working person's machine. (in VB editor select
Tool-Reference Libraries)

Or

There is some data inconsistancy in the [ToCompany] field. Perhaps its
not a number or there is """ or "'" in the field which is confusing
the concatenation.

Does it work without including the str() function?

Mat N

cridings@usatoday.com (MT 2MB) wrote in message news:<f0b569b6.0407010645.1b4483a0@posting.google. com>...[color=blue]
> I created an access journal entry program many years ago. It works
> for all and was working for an individual until recently. The report
> shows ?Name! for every instance it repeats in the report. The field
> in the report is a text box: named Text12. Bad coding I know. The
> concat goes like this...
>
> =Str([ToCompany]) & "-" & [AcctUnit] & "-" & [Account] & "-" &
> [SubAcct]
>
> ToCompany is a number. Like I said it works for all others but one
> person. I wonder if there is a PC dll issue. I would love any help
> you can provide.
>
> Chris[/color]