Results 1 to 3 of 3
  1. #1
    Cran29 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    38

    Record set wont enter Data

    I have a simple Data base attached it wont let me save records as it says Empoyee table not record set. I am stuck i have tried various methods with no luck. Any body care to have a look and see where i have gone wrong.
    Attached Files Attached Files

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    I'm not sure what your set up is and what you are trying to do. However, the error is because of your keys or lack of key.
    See keyProblem.jpg

    A possible alternative, and it's only a guess on my part, is shown in the other jpgs.

    It may be a simple data base to you, but until readers understand what you're trying to do, it isn't simple.
    Good luck.
    Attached Thumbnails Attached Thumbnails KeyProblem.jpg   AdjustedRelationshipsAndTable.jpg   RevisedRelationships.jpg  

  3. #3
    Cran29 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    38
    Solved another table and some keys. The simple data base became complicated as each employee could have the same documents presented to him on different dates.
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 11-21-2012, 01:41 PM
  2. Access wont insert the record
    By chaitanyakvs in forum Queries
    Replies: 1
    Last Post: 03-01-2011, 10:25 AM
  3. Form wont add data from a combo box
    By bopsgtir in forum Forms
    Replies: 9
    Last Post: 01-02-2011, 07:26 AM
  4. Replies: 4
    Last Post: 12-16-2010, 12:45 PM
  5. All Data wont show
    By Wrangler in forum Queries
    Replies: 1
    Last Post: 01-02-2006, 03:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums