MS Access 2010 - Navigation Pane Problem - Can't get "Modules" Group to Appear

I want to start using VBA modules (something I have never done before), but the "Modules" group does not show in the Navigation Pane along with Tables, Forms, Queries, Macros, etc.

I verified carefully that it is checked in the Navigation Options dialog box, but I just can't get it to appear in the Navigation Pane so I can work with VBA.  

Any ideas?  Many thanks in advance.

WallyTee
WallyTeeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GrahamSkanConnect With a Mentor RetiredCommented:
The group will only be there is already at least one code module.

As jo implies, you can open the VBA editor with Alt+F11. Once there, use the Insert menu item to add a Code module
0
 
jo_mCommented:
have you tried pressing  F11 it works in all previous  versions

otherwise Alt F11 was used in excel if I recall correctly

tx

jo
0
 
WallyTeeAuthor Commented:
Thanks folks --- I'll try your suggestions  right away.    WallyTee
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Gregory MillerGeneral ManagerCommented:
You have to create either a standard module or a class module and then save it for it to appear in the navigation pane. The VBA associated with the Forms or Reports will not appear in the Modules navigation pane.

Direct access to the VBA environment is Alt-F11 as mentioned by jo_m above. You can also use the Alt-F11 to switch back to the Access window. Handy if you want to open both full screen on a single monitor and quickly switch between the two.

-greg
0
 
WallyTeeAuthor Commented:
From WallyTee:  It worked!  Many thanks.  I simply created and saved a new VBA module (my very first) and that fixed the Navigation Pane problem.   Many thanks again.   WallyTee.
0
 
WallyTeeAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for WallyTee's comment #37760649

for the following reason:

All suggested solutions worked fine.
0
 
Gregory MillerGeneral ManagerCommented:
Please accept one or more of the Expert comments and assign point appropriately. I Do not agree with the disposition of this question.
0
 
WallyTeeAuthor Commented:
I must have inadvertenly omitted part of the 'acceptance' process.  My apologies.  Several experts have helped me immensely today on three different questions.  WallyTee
0
 
WallyTeeAuthor Commented:
Good answer.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.