Ms app crash. :(

[pr2-eugin]

Well, All I tried to do was to create a form called main interface and used buttons to open various other forms/reports, such as Search, Reports.. Then i tried changing the Customers form(which was set to be displayed on opening the database), to Main Interface form.

I used the Options-->CurrentDB-->Display form as Main Interface from Customers. It stated i need to close and reopen the batabase inorder to continue changes. I did it, then the main interface opened up just fine, but when i clicked the reports, or any other button on the form,MS APP CRASH window appears. I used the backup i stored in my system at different location and I tried doing the design again (twice) but still i am getting the app crash error. Why is this happenenig? any way to overcome this?

I am including the detailed error if that helps.

Problem signature:
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 14.0.6024.1000
Application Timestamp: 4d83e4fc
Fault Module Name: VBE7.DLL
Fault Module Version: 7.0.16.19
Fault Module Timestamp: 4d430aec
Exception Code: c0000005
Exception Offset: 0001d942
OS Version: 6.1.7600.2.0.0.768.3
Locale ID: 2057

Additional information about the problem:
LCID: 1033
skulcid: 1033

Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt

Any help will be appreciated. Thanks.

 

[vbaInet]

* How many versions of Access are you running on your machine?
* How is your database split?

 

[pr2-eugin]

I have only one version. And i have not split my database yet. That was my final step.

 

[vbaInet]

I suspect your form has been corrupted. Can you make design changes to any other form?

Create a new form, make a design change and save it. Does it crash?

 

[pr2-eugin]

as a matter of fact, only the customer form is causing the crash, because as i mentioned i tried doing again, changed the other form it worked fine, but anything related to the customer form a report that is linked with customer form on click is causing the crash.. so does it mean the customer form is corrupted? how can i find where it is exactly causing trouble?

 

[vbaInet]

so does it mean the customer form is corrupted? how can i find where it is exactly causing trouble?

Yes. There's no way of finding out where the corruption exists.

Your best bet is to recreate the form from scratch.

Or

Follow these steps (on a backup copy):

1. Save the form as text:

SaveAsText acForm, "[COLOR=Red]FormName[/COLOR]", "[COLOR=Red]...path to a text file ...[/COLOR]"

2. Delete the form
3. Save the database
4. Debug > Compile
5. Save the database
6. Compact & Repair
7. Load the form from the text file (with a new form name):

LoadFromText acForm, "[COLOR=Red]NewFormName[/COLOR]", "[COLOR=Red]...path to the text file ...[/COLOR]"

8. Save the database, Debug > Compile, Compact & Repair

If you're unsure of any step, please ask.