Results 1 to 13 of 13
  1. #1
    thinker74 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    7

    how to make saved records NOT editable in Access 2010

    Hello,


    I am building a db to log calls (fields: ID, date, time, name, phone, address, issues...) and want to make it so that after the data is saved, the record (all fields) is not editable through form or table. I check out some threads but the closest I get is:

    If Not Me.NewRecord Then Me.ComboBoxName.Enabled = False Else Me.ComboBoxName.Enabled = True End If

    The problem is I have like 30 fields. Is there a way to do this to all fields on the form without using the above code for every single field?
    Thank you very much in advance for all your help.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Why are you using a Form if you don't want the records to be editable (Forms are generally used for data entry/manipulation)?
    Why not use a Report instead?

  3. #3
    thinker74 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    7
    I am collecting data for quality assurance and survey purpose. I need the form to enter data, but old data is legally required to be untouchable.

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Personally, I might consider just making an Entry Only Form (does not show any existing data), and only show old data through Reports.

    However, you can create a Form that will show old data, but not let you edit it, while at the same time allowing you to enter new data.
    Just go to the Properties of your Form, go to the "Data" tab, and change the "Allow Deletions" and "Allow Edits" properties to "No", while leaving the "Allow Additions" properties at "Yes".

  5. #5
    thinker74 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    7
    Great, that trick does the job and is simple enough for a newbie like me. I will use that for now. But if you can also show me how to do it the way I originally thought of, I would love to learn that as well. Thanks a bunch and have a nice day.

  6. #6
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    But if you can also show me how to do it the way I originally thought of, I would love to learn that as well. Thanks a bunch and have a nice day.
    I haven't done it like that, but I suppose you could use VBA to loop through all the objects on your Form and disable them.
    See here: http://www.devhut.net/2010/12/05/ms-...ols-on-a-form/

  7. #7
    thinker74 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    7
    Thanks. I've look at other options and one of them is to convert the db to accde, which I did but I have no idea how to use this accde. I open the file, there is the form as usual but there is no table. I thought it's hidden somewhere but when I try to generate a report, there is no data returned. Sorry for keep asking all the dumb questions.

  8. #8
    thinker74 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    7
    Quote Originally Posted by thinker74 View Post
    I thought it's hidden somewhere but when I try to generate a report, there is no data returned.
    Correction: the Report options are not enabled.

  9. #9
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

  10. #10
    thinker74 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    7
    Thanks. I found the issue.Basically I have to create the reports before converting the db to executable.

  11. #11
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Yes. Usually, you just use the Compiled version for distribution. You will want to keep a copy of the uncompiled version (accdb) in case you need to make changes/updates. You would just make the changes to your accdb, then create a new Compiled version to distribute.

  12. #12
    thinker74 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    7
    Got it. Thanks for all the help. You are great. Happy Thanksgiving and have a nice weekend.

  13. #13
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Thanks! Happy Thanksgiving to you too!

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

Similar Threads

  1. Make sub query un-editable
    By esh112288 in forum Forms
    Replies: 2
    Last Post: 11-11-2012, 06:35 PM
  2. Replies: 2
    Last Post: 08-09-2012, 04:15 AM
  3. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  4. Populate Form And Make Editable
    By Rick5150 in forum Forms
    Replies: 1
    Last Post: 10-04-2011, 09:04 AM
  5. Access 2010 Saved Imports
    By Tomfernandez1 in forum Access
    Replies: 1
    Last Post: 09-27-2011, 12:27 PM

Tags for this Thread

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