Where did my Module go?

Sometimes when creating a new Module in Access it does not show up in the Navigation Pane.  So you’ve pressed new and went off to do something else and now you’re ready to use your new Module but where is it?  Well, it’s still there but for whatever reason it is not showing.  (Yep, it’s happened to me!)  Don’t panic, follow one of these two steps to make it reappear…

1. Open any existing Module (or anything in Design View) and press *Save*.  In the window that opens you will see you are being prompted to Save your new Module.

2. “Another way that sometimes works is to just use Debug > Compile (found in the VB Editor) and, if there is a duplicate, it will say so and take you there. ”  Courtesy of Bob Larson

 1,008 total views,  2 views today