Solved

Access 2010 Navigation Pane - no Macros and no Modules

Posted on 2011-03-20
3
798 Views
Last Modified: 2012-05-11
I’m going stir crazy trying to adapt to Access 2010.  Things go along ok and, then, a mystery.  I’ve spent far too much time trying to resolve this problem re the Navigation Pane. The Navigation Options (see below) is how I have it set up.

However, when I click on All Access Objects on the pane I do not see either Macros or Modules.  See what the pane looks like below.  Note that Object Type and All Access Objects both have check marks in front of them.  (Note: I couldn’t use the snipping tool to make a copy of the actual pane so I did a lookalike in Word without the check marks.)

I’m guessing that this is a security permissions problem of some kind but I cannot seem to find where the resolution is buried.  I have other 2010 db’s that are ok.  This is a brand new blank accdb….haven’t done a thing to it.  I had a previous accdb with a form in it, but same problem.
 Navigation Options Navigation Pane
0
Comment
Question by:WFBweb
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 200 total points
ID: 35176211

 You won't see the group until you create something.

JimD.
0
 
LVL 75
ID: 35176276
Which ... IS somewhat annoying I must say.

I certainly miss what you see in the screenshots below.

mx
Capture1.gif
Capture2.gif
0
 

Author Comment

by:WFBweb
ID: 35176481
The first db I had this prob with did have a table in it (imported) and a form.  However, I decided to import both a macro and a module from a previous db and that did the job.  Weird!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now