On 1 Jul 2004 07:45:06 -0700, MT 2MB wrote:
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
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.