Results 1 to 6 of 6
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151

    Problem saving changes to an old form

    I am trying to change a form that was created about 10 years ago. It asks if I want to save, I say yes. When it brings it back up, the changes are gone.

    I tried copy and pasting the form to one with a new name, and get the following error (I am using a unique name):
    "Name conflicts with existing module, project, or object library."

    Any help would be greatly appreciated.

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,700
    Try commenting out all the vba code in the original form.

  3. #3
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151
    There is no vba code. However, one additional, possibly important detail. I am trying to change a form with tabs (or pages). It is the second tab I am trying to change. It seems to make the changes, when I finish adding the new fields, I save, then go to form view. All looks OK. When I close the database and reopen it, the changes are gone.

  4. #4
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151
    I finally decided something had to be corrupted. I recreated the subform from scratch and it saved and is working fine now.

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Sounds as if corruption was, indeed, the problem. Next time, if corruption is suspected, you might want to try this:

    From inside Access:

    1. Click on the 'New' or use <Control> + <N>
    2. Go to top of the Ribbon and click on External Data
    3. Under that click on the Access Icon
    4. Click on Browse
    5. Find your errant Database File
    6. Click OK
    7. Tab by tab, go thru Tables, Queries, Forms, etc, clicking on 'Select All' each time
    8. When done selecting all Objects, click on OK

    You should now be set. If everything now works, delete the old file and rename the new one as the old. Amazingly, this works an enormous percentage of the time, and is usually easier than re-creating a Form or Forms.

    Linq ;0)>

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,700
    Yes, I've run into that sort of problem several times. I've had vba code give errors for no apparent reason, and cutting and pasting the code to another place in the same module fixes it. I really hate having to recreate a form. Such a boring waste of time, but can't be avoided sometimes.

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

Similar Threads

  1. Replies: 10
    Last Post: 10-22-2013, 07:35 AM
  2. when saving a record problem
    By sireesha in forum Access
    Replies: 7
    Last Post: 01-30-2013, 05:44 AM
  3. saving problem
    By jillp in forum Programming
    Replies: 5
    Last Post: 09-26-2012, 02:02 AM
  4. saving default value to field problem
    By sk88 in forum Access
    Replies: 3
    Last Post: 01-08-2012, 01:15 AM
  5. problem while saving database design
    By Ramya in forum Database Design
    Replies: 1
    Last Post: 08-02-2011, 07:39 AM

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