Forum Discussion
LeonelSantizo
Apr 21, 2021Copper Contributor
Microsoft Access Closes unexpectly
Microsoft Access is closing unexpectedly. The strange thing is that sometimes the forms I have designed work correctly and other times the program closes unexpectedly. I think it has something to do ...
Beno9
May 10, 2022Copper Contributor
Same problem. Access is closing whenever I Edit a VBA code.
Thanks for your help.
Thanks for your help.
George_Hepworth
May 10, 2022Silver Contributor
Beno9 It's not clear. Are you thanking the original poster? Or are you asking for help for yourself?
If the latter, we need a lot more context before we can offer any suggestions beyond the generic ones.
Make sure your code compiles. Make sure all variables are defined. Make sure EVERY module has Option Explicit at the top. Compact and Repair the accdb. Do NOT try to edit VBA in break mode.
- Beno9May 15, 2022Copper ContributorMany thanks for your message. Being new to Tech Community, I have noticied your reply lately. I am asking for help for my self. I have almost the same problem as LeonelSantizo, therefore I thought it would a good idea to join this post instead of opening a new one.
Concerning the shutdown of MS Access whenever I edit VBA, the Option Explicit is added, Compacting and Repairing the accdb is done, but the problem is still there. There is no single error in the forms, tables and queries that I have created. Macros run smoothly.
No VBA code yet. I am using Office 365 family subscripton, multiple languages on Windows 10 Pro up-to-this-date.
Do you have any idea?- Beno9May 19, 2022Copper ContributorThe problem has been resolved in my case by changing Country and Regional Format in the setting of Windows 10 to the desired language.