1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: #Name? Error in access 2007

Discussion in 'Business Applications' started by obatusai, Nov 13, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    Can some one help me, I'm geting this error in my DB showing this error in some fields that show data stored on tables. how can I correct this? :confused:
     
  2. Sponsor

  3. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,617
    Check your Field Names on your Forms
     
  4. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    they seem to be fine! they match the names from the tables they feed. What do you mean by that?
     
  5. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,617
    This error usually occurs when the Field Name in the Form's Field's Record Source Property does not match that of the Table or query providing the data.
    Have you checked the Form's "Field List"?
    If you can post a zipped copy of the database in Access 2003 version by converting it, we can look at it for you.
    Or post screenshots of the Table in design mode and the Form with a Field with the problem in design mode.
     
  6. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,617
    I can't see anything attached to your last post.
     
  7. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    I'm trying to copy boths the screens and the DB but I don't know how. copy paste won't work
     
  8. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,617
    If you have the Table in design view, use the keyboard fn + Print Screen (prt sc) or Ctrl + Printscreen, that will put a copy of you table design in the Clipboard.
    You can then open a blank Excel Worksheet and Paste the "Image" in to it.
    Now open the Form in design view and click on a Filed that has the #name problem, make sure the the Properties are showing and then use the Prontscreen to capture the image and paste that in the Excel Sheet as well.
    Use the "Go Advanced" and "Manage Attachments" Buttons to post the Excel sheet as an Attachmnent.
     
  9. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    here is the DB, it won't look the same because of the different versions
     

    Attached Files:

  10. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,617
    OK, which form has the problem?
     
  11. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    First Level, Second Level, CVM Review and Manager Review
     
  12. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,617
    On the First Level Form is the problem the Fields down the right hand side?
    Co Code
    Vendor Number etc
     
  13. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    yeap, those are the ones, same in the other forms. actually all fields except for the Date fields
     
  14. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,617
    Ok, those fields are not in the Field List for that Form, this is how to see the field list
     

    Attached Files:

  15. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    Thanks, I see the problem now.
     
  16. obatusai

    obatusai Thread Starter

    Joined:
    Nov 7, 2008
    Messages:
    19
    Thank You, it really worked! everything is working as it should!
    Thanks a lot for your help!
     
  17. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/769023

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice