Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by vikenk@aol.com, Jul 28, 2006.

  1. vikenk@aol.com

    vikenk@aol.com
    Expand Collapse
    Guest

    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.

    --
    Viken K.
    http://www.vikenk.com
     
  2. Loading...

    Similar Threads Forum Date
    Akal Takht Jathedar Labels Pal Singh Purewal as an Agent of RSS Hard Talk Feb 20, 2011
    The Prison of One-Word Labels Sikh Sikhi Sikhism Nov 18, 2009

  3. jahoobob via AccessMonster.com

    Guest

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

    vikenk@aol.com wrote:
    >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.
    >
    >--
    >Viken K.
    >http://www.vikenk.com


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200605/1
     
  4. vikenk@aol.com

    vikenk@aol.com
    Expand Collapse
    Guest

    jahoobob via AccessMonster.com wrote:
    > 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).

    --
    Viken K.
    http://www.vikenk.com
     
  5. fredg

    fredg
    Expand Collapse
    Guest

    On 26 May 2006 08:38:21 -0700, vikenk@aol.com wrote:

    > jahoobob via AccessMonster.com wrote:
    >> 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.

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  6. vikenk@aol.com

    vikenk@aol.com
    Expand Collapse
    Guest

    fredg wrote:
    > On 26 May 2006 08:38:21 -0700, vikenk@aol.com 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.

    --
    Viken K.
    http://www.vikenk.com
     
  7. jahoobob via AccessMonster.com

    Guest

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

    Marcin wrote:
    >> 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
    >
    >==========================================================================


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200605/1
     

Share This Page