-
1
- #1
This story has a very happy ending, except for smacking my forehead really hard when I finally figured it out.
I thought I had lost all my vba code, I opened a form, none of the actions worked.
I went to the vba editor and seemingly it had no underlying subs or funtions, just the header info. After at least a half hour searching, checking other databases, etc... I tried to compile and little by little the compiler stopped me at places where I still had incomplete code.
Finally I looked at tools>options and saw 'default to full module view' was deselected, and realized I had a recent Windows update to thank for Bill Gates apparently thinking deselected was a desirable thing. I clicked the checkbox and now all my code reappears.
Now back to debugging why that first form wouldn't work, but at least now I can see the code that I thought was gone.
I thought I had lost all my vba code, I opened a form, none of the actions worked.
I went to the vba editor and seemingly it had no underlying subs or funtions, just the header info. After at least a half hour searching, checking other databases, etc... I tried to compile and little by little the compiler stopped me at places where I still had incomplete code.
Finally I looked at tools>options and saw 'default to full module view' was deselected, and realized I had a recent Windows update to thank for Bill Gates apparently thinking deselected was a desirable thing. I clicked the checkbox and now all my code reappears.
Now back to debugging why that first form wouldn't work, but at least now I can see the code that I thought was gone.