#NAME?

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

I am combining data from two or more text fields from a
query in Access 97 to a new textbox on a report. My text
boxes are all named differently from the field names.
This works fine on any machine that has had the full
blown version of Access 97 loaded.

I am now running a Runtime version of the program on most
of the machines. On any machine where Access has not
been installed, I get the #NAME? error on the report.

I have registered all files that I know to. When I
install the complete version of Access 97, the problem
disappears.
EXAMPLE 1:
=([TP_ADDR]+", "+[TP_CITY]+", "+[TP_STATE]+" "+IIf(Len
([TP_ZIPCODE])>6,Left([TP_ZIPCODE],5)+"-"+Right
([TP_ZIPCODE],4),Left([TP_ZIPCODE],5)))

The textbox name on the report for Example 1 is
txtAddress.

EXAMPLE 2:
=IIf([TP_POAFirm]="None","None",[TP_POAFirm]+" "+
[TP_POAName]+" "+[TP_POAAddr]+" "+[TP_POACity]+", "+
[TP_POAState]+" "+IIf(Len([TP_POAZip])>6,Left
([TP_POAZip],5)+"-"+Right([TP_POAZip],4),Left
([TP_POAZip],5)))

The textbox name on the report for Example 2 is txtPOA.

I have tried the "&" instead of the "+" signs and it did
not make any difference.
 
Most likely this is a references issue. I would check the references on your
main PC and uncheck anything that you are not using. Then try again on the
runtime PC.
 
Back
Top