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?
 
GrahamSkanRetiredCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.