• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 799
  • Last Modified:

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
0
WallyTee
Asked:
WallyTee
1 Solution
 
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
 
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
 
WallyTeeAuthor Commented:
Thanks folks --- I'll try your suggestions  right away.    WallyTee
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now