Results 1 to 6 of 6
  1. #1
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88

    Form Locked and don't know how!


    i usually write using access 2013 but i'm trying 2016 now. i'm rewriting a DB already have and found some things that are different with 2016. my main issue is that my form is locked even though I did not told it to. i do not have any .Locked = true anywhere. even writing .Locked = false under Form_Load() won't open it. all I have are .Enabled = true and also some False but for buttons and fields and such. what can it be causing this? thnx.

    btw...Records Locked is No as well as every field, buttons, etc.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Does form have a query as RecordSource? Is the query editable?
    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.

  3. #3
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88
    Quote Originally Posted by June7 View Post
    Does form have a query as RecordSource? Is the query editable?
    yes it does...how to I check if its editable or not? it was working until a few hours back. I've taken the entire code out, saved it and run it again and all still locked...wtf!

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    If you can open the query and edit data then it is editable.

    Have you checked the form AllowEdits, AllowAdditions properties?

    Otherwise, without examining db, I cannot figure out why form does not allow edits.

    Try building a new form.
    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
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88
    Quote Originally Posted by June7 View Post
    If you can open the query and edit data then it is editable.

    Have you checked the form AllowEdits, AllowAdditions properties?

    Otherwise, without examining db, I cannot figure out why form does not allow edits.

    Try building a new form.
    copy that...thnx for your help...i did checked on all that...it all seems ok...i started another one...more hours to get where I was but for me its part of the fun...i will however make a copy at certain points just in case.

  6. #6
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88
    ok so if I do .Enabled= false on Form_Load() it locks the whole thing...even if I remove that and put it in Form_Current()...must be a bug.

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

Similar Threads

  1. Form locked when using calculated field
    By mikelaccess in forum Access
    Replies: 3
    Last Post: 05-08-2017, 01:03 AM
  2. Replies: 4
    Last Post: 08-03-2015, 05:18 AM
  3. Edit Button for Locked Form?
    By tanyalee123 in forum Forms
    Replies: 6
    Last Post: 11-21-2013, 02:04 PM
  4. Form locked - won't allow new record
    By mhart in forum Forms
    Replies: 4
    Last Post: 02-22-2012, 02:46 AM
  5. form locked backend side
    By abner in forum Forms
    Replies: 5
    Last Post: 09-10-2011, 12:09 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