Forum Discussion
MS Access 2010 crasing on moving from Form Open to Form Design
Hi all, I have Office 2010 and use Access for hobby use. Lately, the database is crashing when I click on the screen header and select Design View from a Form View. I have attempted to - Compac...
Hi Karl,
It happens, most times, When I'm changing from View to Design mode with any form in the db but not every time. It's a bit like Russian Roulette. You just never know...
The db was first started around 2013 and has been reliable until recently. A suggestion that an Office or Windows update might the cause was made on the Access World Forum. I followed an instruction to remove an update but that had no effect.
I would be grateful for any help.
Dave
It happens, most times, When I'm changing from View to Design mode with any form in the db but not every time. It's a bit like Russian Roulette. You just never know...
The db was first started around 2013 and has been reliable until recently. A suggestion that an Office or Windows update might the cause was made on the Access World Forum. I followed an instruction to remove an update but that had no effect.
I would be grateful for any help.
Dave
Hi Karl,
I did create a new db and imported all the objects into it. The same result.
The database isn't compiled so I did a few Compact and Repair attempts with no effect.
I created a new db and a new form and haven't had the problem so far.
Since your last reply I have been substituting forms from previous aschives and got back to 2019 before the problem went away. Which is odd considering the bug only started a few days ago.
Now, I'm going to return to the troublesome form and start removing objects to if I can identify the nasty bit.
When, and if, I find something I will let you know.
Thanks for you help and suggestions thus far.
Dave
I did create a new db and imported all the objects into it. The same result.
The database isn't compiled so I did a few Compact and Repair attempts with no effect.
I created a new db and a new form and haven't had the problem so far.
Since your last reply I have been substituting forms from previous aschives and got back to 2019 before the problem went away. Which is odd considering the bug only started a few days ago.
Now, I'm going to return to the troublesome form and start removing objects to if I can identify the nasty bit.
When, and if, I find something I will let you know.
Thanks for you help and suggestions thus far.
Dave
Hi Dave,
If you can narrow it down to one or a few problematic forms, then you have at least 3 options:
- replace the form from an old copy
- recreate the form, you can copy the text code over, usually also the non-complex controls
- If 1+2 are too laborous, you can try to export the form as text, then delete it, compact the db and reimport the form. This procedure often removes corruptions from forms (or other Access objects). It can be done from the immediate window with
'export
Application.SaveAsText acForm, "MyForm", "c:\MyForm.txt"'import
Application.LoadFromText acForm, "MyForm", "c:\MyForm.txt"
Servus
Karl
Access News
Access DevCon- Had a problem using the Immediate window. I copied your export command to the window and changed the MyForm:
Application.SaveAsText acForm, "MainOptions", "c:\MyForm.txt"
I got the error message:
Our Garden Database can't open the file "c:\MyForm.txt"
The forms was open in VB View to access the Immediate window.
I copied and pasted your command and just altered the Form name
Where am I going wrong?
DaveHi Dave,
My example path might not have been the best example. 😉
The root folder of c: by default is forbidden in Windows. Instead use any drive/path you are allowed to use in your system or e.g. the same path as the db with:
Application.SaveAsText acForm, "MainOptions", CurrentProject.Path & "\MainOptions.txt"
Servus
Karl
Access News
Access DevCon
