Results 1 to 5 of 5
  1. #1
    Dscalf1 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2017
    Posts
    17

    Exclamation How to edit data in a table

    Hey,

    Im just trying to get everyones ideas on how to do the following.

    I have an action item tracker access database that I am trying to make as user friendly as possible. I have a form where they submit action items but eventually they will have to edit the items they submit, for example editing a due date or adding notes or changing who it is assigned to things like that. Right now they are doing it in excel and it seems fine. I dont want them to have to use a form to edit this data because at any given time they can be hundreds of action items.



    I wanted them to edit it directly in the table, but I read you are never supposed to use a form to go directly to a table. I just am trying to find the easiest way for them to see all the items, be able to sort the items, and then edit the ones they need to and save it. Any ideas?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I use a form for the user to lookup their record.
    they click a button to open a single record form. They DO edit direct from the table.
    they cannot delete,but they edit.
    never had a problem.

  3. #3
    Dscalf1 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2017
    Posts
    17
    But what if I wanted them to see all the records at once in a table format not in the form format I created.. I want them to be able to pull them all up and sort to find the records they want and edit from there...

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Users should never work directly with tables and queries, only forms and reports.

    A form can be in Datasheet view or Continuous view to display all records. Bind form to table or to query or to SQL statement.

    Explore the intrinsic Split form object.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Dscalf1 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2017
    Posts
    17
    Split form worked great!! Exactly what i was looking for thanks!

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

Similar Threads

  1. Search table in form / edit data in form
    By Guitarzan in forum Access
    Replies: 3
    Last Post: 10-02-2012, 11:37 AM
  2. Unable to edit data in Union table
    By D4WNO in forum Access
    Replies: 2
    Last Post: 08-15-2012, 06:56 AM
  3. Prevent edit or delete data or records from a table
    By mosquito_admin in forum Security
    Replies: 1
    Last Post: 03-01-2012, 06:02 PM
  4. Replies: 2
    Last Post: 02-13-2012, 02:41 PM
  5. UnMatched Data Query (Edit Data)
    By pedraza4 in forum Queries
    Replies: 3
    Last Post: 06-16-2010, 07:29 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