Results 1 to 2 of 2
  1. #1
    phineas629 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    47

    command button for allow edits

    I want to emphasize users to be careful of editing data in a specific table, but I want them to be able to fix previous data entry errors.

    I know i can go into the data tab of property and select "no" for 'Allow edits'. Is there a code or something I can put into a command button to change "Allow edits" to a "Yes'?

    Or is there another strategy to limit accidental changes to data?



    Btw, I'm still new to learning codes.

    Thanks

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    In a word, yes.
    Put a button on your form and set it's OnClick property to Event Procedure. Click on the ellipsis (far right of the line) to create the procedure. You should see something like Subroutine Button1_OnClick.
    Using VBA code, set
    Namex.AllowEdits=True
    After the update, you may want another event procedure reset the AllowEdits to No.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-27-2010, 02:27 PM
  2. Command Button
    By nashr1928 in forum Forms
    Replies: 2
    Last Post: 07-05-2010, 08:02 PM
  3. Command Button
    By nashr1928 in forum Forms
    Replies: 1
    Last Post: 07-05-2010, 07:05 PM
  4. Command Button
    By lannoe in forum Forms
    Replies: 1
    Last Post: 07-01-2010, 01:48 PM
  5. Command Button Help!
    By arthura in forum Programming
    Replies: 3
    Last Post: 06-30-2009, 12:55 PM

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