can't save changes in design view (form)

[joseph]

I have a rather simple database that records specific data. There is only one
table and four forms. In all but one form, I can make changes to anything,
layout, fonts, fields, you name it. However, for one of the forms (the one I
actually need to change) I can see the changes on the screen however when I
click save and then close, ACCESS 2007 asks "Do you want to save changes to
the design of form 'frmAppointeeDataEntry'?"

if I click yes, the same message pops up again, almost like a loop, the only
way I can even close the form is buy clicking no, and NOT saving the changes
....

any suggestions out there?

Thank you much much

 

[Allen Browne]

Sounds like something has gone wrong with the form.

Follow the steps here (in order):
Recovery sequence - Standard steps to recover a database
at:
http://allenbrowne.com/recover.html

 

[joseph]

Allen,

Thank you for the reply. I went through the steps and when I got to step 7,
compile the database, I could go no farther. After hitting Ctrl G ... the
name of my database appears in the upper left window, however, it does not
give me the option of selecting the various contents and the "compile" option
is greyed out and won't let me click

Joseph

 

[Allen Browne]

Create a new (blank) database.
Turn off Name AutoCorrect.
Set the same References (in the code window) as your problem db.
Import everything from the old db (from the External Data tab of the
ribbon.)

I'm assuming this is not an MDE/ACCDE file.

 

[joseph]

Thank you Allen,

I've completed the first 2 "easy" steps. When I open the problem db and hit
ctrl g there is no code listed ... am I selecting the code for the entire db?
or only the form that was having the problem?

then for step 4, am I importing every table, form, qry into the new db? (I
ask only because it appears I would have to do this one by one.

Thank you again (also, I emailed you directly on Monday and hadn't seen a
reply, thought maybe it went to spam and I inadvertantly deleted your
response)

Joseph

 

[Allen Browne]

Step 3 (sorting out references) should work whether any code is actually
shown in the code window or not.

Step 4 can be performed as one step, i.e. you select all tables, all
queries, all forms, etc, and import them all at once.

Please keep the discussion here. I cannot respond to non-commercial emails.
(And spam is a problem: I've deleted around 3,000 spams just in one hour
today.)

 

[joseph]

Thank you Allen (sorry about the additional spam)

step 3 I have figured out and is set.

step 4 ... if I select all tables, queries, forms and reports and then right
click, select export the field for export to access db is greyed out ...
however, I just went ahead and did them one by one ... I ran into a problem
w/ one report, I got the following message "Name conflicts with existing
module, project, or object library" I then hit ok and another message states
"No Current Record"

? ? ?

Joseph

 

[Allen Browne]

You can import into the new database in one step (not export from old.)

Anyway, it sounds like you have identified the culprit. If you select all
*other* objects for import, you have everything valid in your new database,
and one report to recreate.

If it's a particularly complex report, you could try the undocumented
SaveAsText/LoadFromText, but I'm guessing it's hosed.