Results 1 to 5 of 5
  1. #1
    gunterbrink is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    16

    Question Error 3113 learning access


    So I apologizeAdd emplyee db.accdb, I'm trying to learn access/ vb script and trying to perform what should be a simple task. I have a set of employees, I want to add an employee, edit them, delete them, clear the form and close the form. I can get everything to work except the edit, then update button? I have looked, and gone through the sample provided, but I can not find the problem. I have attached the db. Any help, and explanation to the problem would be greatly appreciated.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    For starters, EmpID is an autonumber field, thus can't be edited by the user.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    gunterbrink is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    16
    So how would I go about changing that? Insert a new field called EmpID and leave the other field1?

  4. #4
    gunterbrink is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    16
    That fixed it. Sorry, rookie mistake, but thank you for the info and explanation

  5. #5
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Glad you got it sorted. Normally you wouldn't let the user edit the key field anyway.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Where to start learning microsoft access ?
    By fawadmz in forum Access
    Replies: 1
    Last Post: 10-15-2012, 01:16 AM
  2. I'm stumped with learning VBA in Access
    By phineas629 in forum Programming
    Replies: 2
    Last Post: 01-06-2012, 04:57 PM
  3. Learning Access - Design Questions
    By learning_access in forum Database Design
    Replies: 2
    Last Post: 02-15-2011, 09:13 AM
  4. Learning access, need work.
    By akius in forum Access
    Replies: 2
    Last Post: 07-06-2010, 12:42 PM
  5. Learning Access...need help.
    By Banner in forum Queries
    Replies: 1
    Last Post: 10-12-2009, 02:48 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