Results 1 to 3 of 3
  1. #1
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212

    How can forms or data be constructed to prevent deletion whilst allowing data entry?

    I have a category of data that caused real problems if records are deleted. I haven't come across this before.


    I remember the use of a do not delete flag but not how it works exactly. So I would like to learn of foolproof methods for not letting the user delete data in a database that is not restricted. We make changes with user to objects etc, so the database is open.

    I can use warnings on the form etc.

    Any ideas would be welcome. Thanks

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    As long as users are only accessing data through Forms, this can be done (users should never be going to/editing Tables anyway; databases should always be Form driven).

    If you go into Design View of your Form and open the Properties, on the Data tab, there is an "Allow Deletions" property. Just set that to "No".

  3. #3
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    Thanks, really appreciate fast response, and specific answer.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-05-2014, 09:16 AM
  2. Data Entry into Forms
    By Lasso in forum Forms
    Replies: 5
    Last Post: 08-27-2014, 10:19 PM
  3. Replies: 3
    Last Post: 05-29-2013, 02:34 PM
  4. Replies: 2
    Last Post: 02-29-2012, 12:51 AM
  5. Replies: 7
    Last Post: 03-22-2011, 10:36 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