When clicking on a button with an embedded macro in Access 2010, the application is crashing. It usually crashes right after loading Access and clicking on the buttons, then, after a while will work a few times, then start crashing again. The buttons are just opening a form but I get the following error message, which I believe means that the application has malfunctioned and is trying to reference NULL:
Problem signature:
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 14.0.7104.5000
Application Timestamp: 51ce12f7
Fault Module Name: MSACCESS.EXE
Fault Module Version: 14.0.7104.5000
Fault Module Timestamp: 51ce12f7
Exception Code: c0000005
Exception Offset: 000fca03
OS Version: 6.1.7601.2.1.0.256.4
Locale ID: 1033
Additional Information 1: c3d2
Additional Information 2: c3d2796f57bf8f0f015fe1cefa82ba2b
Additional Information 3: 73c7
Additional Information 4: 73c73978374743d3cb1d140dc61b71f0
When I tried to change the macro code to vba, the "Convert Macros to Visual Basic" is grayed out so I tried to change it to an event procedure to open the form. However, that gives me a "Run-time error '28': Out of stack space" error.
I've checked my vba code and cannot find any recursive calls. I do have quite a bit of code but the code seems to be working fine.
Any assistance would be appreciated.
Access 2010, version 14.0.7128.5000 (32-bit), 16GB RAM