Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page