Get "#ERROR" on labels on mailing list. Why?

[vikenk]

Hello everyone,

Years ago, I had created a Mailing list DB using Access 97 for my
cousin. She was using it on an old computer. She recently bought a new
computer with Office 2003. When she views the mailing labels with
Access 2003, she sees a #ERROR message where the person's name should
be.

Try as I might, I haven't been able to remove this error, even after
converting the DB to Access 2003 format and creating a totally new
mailing labels report from scratch.

Here's a couple of screenshots:

http://www.vikenk.com/db_screenshots.htm

How can I fix this?

Thanks in advance for any advice.

 

[jahoobob via AccessMonster.com]

From where does [Report]![Name] come? Looks to me it should be just [Name].

 

[vikenk]

From where does [Report]![Name] come? Looks to me it should be just [Name].

I'm not sure. I used thew Label Wizard to make the labels. When I
remove [Report]! from the Design, all the names get replaced with the
name of the form, like this:

http://www.vikenk.com/db_screenshots.htm (see the last screen shot).

 

[fredg]

From where does [Report]![Name] come? Looks to me it should be just [Name].

I'm not sure. I used thew Label Wizard to make the labels. When I
remove [Report]! from the Design, all the names get replaced with the
name of the form, like this:

http://www.vikenk.com/db_screenshots.htm (see the last screen shot).

Access is working correctly when it returns the name of the Form if
you remove [Report] from the expression.

Name is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

If you are getting an #Error, make sure the name of the control is not
the same as the name of any field in the control source expression.

 

[vikenk]

On 26 May 2006 08:38:21 -0700, (e-mail address removed) wrote:

Name is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

OK. Changing the name of the field to, say, F_NAME would help to solve
the problem? Thanks for the help.

 

[Marcin]

Hello everyone,

Years ago, I had created a Mailing list DB using Access 97 for my
cousin. She was using it on an old computer. She recently bought a new
computer with Office 2003. When she views the mailing labels with
Access 2003, she sees a #ERROR message where the person's name should
be.

Try as I might, I haven't been able to remove this error, even after
converting the DB to Access 2003 format and creating a totally new
mailing labels report from scratch.

Here's a couple of screenshots:

http://www.vikenk.com/db_screenshots.htm

How can I fix this?

Thanks in advance for any advice.

=========================================
===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================

 

[jahoobob via AccessMonster.com]

Take your SPAM and shove it! I have made the moderators aware of this.

Hello everyone,

[quoted text clipped - 19 lines]

Viken K.
http://www.vikenk.com

=========================================
===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================