Results 1 to 4 of 4
  1. #1
    virgilio is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    81

    Can't save and close form

    I find that I am unable to save and close a form that I have been working on. I have only been editing the VBA and I have made a significant amount of changes in the VBA editor, save them and can see the changes take effect. But when I go back to Access I am prompted to save changes and close form. If I select "yes" nothing happens and the form doesn't close, If I select "no" all of my VBA changes have reverted to where they were at the beginning of the day.



    EDIT: also the 'X' is missing from my form when open in access

    I might have set this form to not allow edits at some point, but I switch languages pretty frequently and can't for the life of me figure out where I did it at.

    Any ideas?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you go into a form code edit mode (design) and type nothing, and exit , it will ask you to save.
    So, just save as a matter of habit. Whether you change the code or not.
    saying NO will cause you to lose all edits.

    this has no effect on the data.
    saving data is automatic once you move off the record.

    while editing code, I press Ctl-S (save) every 5 minutes. Its a reflex now that I dont even think about.

  3. #3
    virgilio is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    81
    Thanks, that explains why the edits are lost. But I'm still looking for a reason why saving repeatedly doesn't save my changes permanently.

  4. #4
    virgilio is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    81
    Found it, as per this link:

    https://answers.microsoft.com/en-us/...c-68b599b31bf5

    DB was corrupted, I selected "Compact and Repair " from DataBase Tools to fix it.

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

Similar Threads

  1. Close form and dont save record
    By Homegrownandy in forum Access
    Replies: 10
    Last Post: 08-05-2015, 03:47 AM
  2. How to disable save/close window in form
    By Kivan in forum Access
    Replies: 2
    Last Post: 08-16-2012, 02:52 AM
  3. Can't save or close form
    By Buakaw in forum Forms
    Replies: 4
    Last Post: 07-26-2011, 04:47 AM
  4. form won't save and close
    By Philislost in forum Access
    Replies: 6
    Last Post: 10-08-2010, 01:47 PM
  5. Replies: 2
    Last Post: 01-29-2010, 11:33 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