form seems to be blocked (1 Viewer)

[Goofer]

I have a form that seems to be blocked. I can't open it, even not in design. Also copying the form is not possible, then I get an new table: Name AutoCorrect Save Faillures with the object's name, type and failure reason with the time. The failure reason: "could not open the object"

I also tried to import the form in a new database, without success.

I deleted all the VB code from the form but event this is not working.

What could be wrong?

 

[HiTechCoach]

Sounds like a corrupt form. I would recover a copy from a backup.l

 

[Dennisk]

The Auto Correct feature is buggy (as you have found out to your cost) , turn it off.

you now have 2 options, either as HiTech pointed out, revert to last backup or recreate your form.

 

[DCrake]

Here is another test you can to see if you can recover the form

Go into the immediate window (Ctrl+G)

Enter the following line of code

Application.SaveAsText acForm, "YourFormName" ,"C:\Temp\YourFormName.Txt"

then press return

Rename or delete the offending form

Next return to the immediate window and enter the following code

Application.LoadFromText acForm,"NewFormName","C:\Temp\YourFormName.txt"

Now se if you can design your new form
If not you can edit the txt file and check to see if there is anything unnatural going on.


David

 

[Goofer]

Thanks for the support.

I simply recreated the form to go on with the application. Anyway, I'll keep in mind the tips.

 

[Tim L]

Here is another test you can to see if you can recover the form

Go into the immediate window (Ctrl+G)

Enter the following line of code

Application.SaveAsText acForm, "YourFormName" ,"C:\Temp\YourFormName.Txt"

...

I've got a similar problem. Unfortunately the Application Save just causes Access to crash.

The initial symptom was Access reporting that it could not perform a Save action on the form due to a lack of system memory. The system was restarted, but no joy.

I've attempted to Export/Import the troublesome form to a different database. I've attempted to copy within Access. I've set it up to open when the database starts. I've tried putting it as a subform in a new form. And, of course, I've used Compact & Repair. All to no avail. The form will not open (in either normal or design mode), import or export. I can see the code, so that's safe, but I can't do anything else with the form.

Is there anything else that could be tried to get the form design back without having to start all over again - unfortunately the most recent back up doesn't have this particular form in it, doh!

Tim