Why do I get "#error" in place of the first line of a label?

[Guest]

I have created an Access database linked to an Excel spreadsheet and now
wishto create a set of mailing labels using the Label Wizard. But every time
I set up the labels and view way the sheet will print the first label field -
Name - is replaced with "#error" and I can't find out what this means.

 

[Guest]

It might be due to the use of 'Name' as the column name. Objects in Access,
including reports, have a Name property so using the name of a property as a
column name can cause confusion. Try either changing the column name or, if
Name is a field in the base table rather than a query's result set, basing
the report on a query in which the Name field is given another name, e.g.
FullName in the result set. To do this put something like this in the Field
row of a column in the query design grid:

FullName: [Name]

In the label report the ControlSource of the control for the first row would
now be FullName.

Ken Sheridan
Stafford, England

 

[John Vinson]

I have created an Access database linked to an Excel spreadsheet and now
wishto create a set of mailing labels using the Label Wizard. But every time
I set up the labels and view way the sheet will print the first label field -
Name - is replaced with "#error" and I can't find out what this means.

In addition to Ken's suggestion, make sure you're not including the
row of column headers as part of the linked table. If you have numeric
or date fields with text headers in the first row of the spreadsheet,
the entire record will be in error if you include that row in the
recordset.

John W. Vinson[MVP]