Link to home
Start Free TrialLog in
Avatar of WallyTee
WallyTee

asked on

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
Avatar of jo_m
jo_m

have you tried pressing  F11 it works in all previous  versions

otherwise Alt F11 was used in excel if I recall correctly

tx

jo
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of WallyTee

ASKER

Thanks folks --- I'll try your suggestions  right away.    WallyTee
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
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.
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.
Please accept one or more of the Expert comments and assign point appropriately. I Do not agree with the disposition of this question.
I must have inadvertenly omitted part of the 'acceptance' process.  My apologies.  Several experts have helped me immensely today on three different questions.  WallyTee
Good answer.  Thanks.