CHANGES TO A FORM WON'T SAVE

Z

ZigZagZak

I am creating a from in access. I have a text box on it I want to delete.
Every time I delete it, and save it.....its back again next time I open it.
I am also having the problem when I change subforms through its parent. If
have to have the subform open by itself it will save correctly.......It seems
that most/all of the problems are generated through this one parent form.
I've been dealing with having to open the subforms by them selves for about a
week now.....but it will not let me change the parent form at all....any
thoughts?
 
A

Arvin Meyer [MVP]

Sounds like a corrupt form. To be safe I'd look at the entire database.
First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
 
Top