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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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.
ASKER
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.
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.
ASKER
I must have inadvertenly omitted part of the 'acceptance' process. My apologies. Several experts have helped me immensely today on three different questions. WallyTee
ASKER
Good answer. Thanks.
otherwise Alt F11 was used in excel if I recall correctly
tx
jo