Quick Access Toolbar --> Button to move to Tables in Navigation Pane

Version --> Access 2010

Question
When I'm programming and the Navigation Pane open and is showing queries, I'd like a button on the Quick Access Toolbar that would move the Navigation Pane to show tables.
Similar button for queries, forms, macros, modules.

The above is presuming the Navigation pane is in Filter by Group mode

I know
I know I can click the down arrow on queries, pick tables - Just say I'm lazy.

Thanks in advance for any help.
LJG
LVL 2
LJGAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
" I created is only available on my computer and does not go along with the database I'm creating"

You can Export Customizations ... lower right of the Quick Access Toolbar dialog window ...

So, you can save it to a file (I believe, then Import into another DB.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
See my response to your other question ...

mx
0
 
LJGAuthor Commented:
DatabaseMX - Thanks

I'm not interested in the Ribbon right now. I know I'll need to learn all about ribbons, but right now I'm interested in  the "Quick Access Toolbar".  It's much more similar to Toolbars in 2003.  I understand the "Quick Access Toolbar" I created is only available on my computer and does not go along with the database I'm creating.  In most cases the Ribbon stays with the mdb/accdb.

I'd like a button on the Quick Access Toolbar that would move the Navigation Pane to show tables.  Also a similar button for queries, forms, macros, modules.
0
 
LJGConnect With a Mentor Author Commented:
This is not exactly what I want, but might be an option.

Create a Macro in the database --> mcr_SelectTable
       Command -->   Select Object
       Object Type --> Table
       Object Name --> tbl_MyTable
       In Database Window --> True

Put the Macro on the QAT
      >>File / Options / Quick Access Toolbar / Choose Commands From -->Macro

     >> With the macro selected in the right window, click modify and pick a nifty icon

You can do the same with Queries, Reports etc.

If you come up with something better, please reopen the question.
LJG
0
 
LJGAuthor Commented:
It adds to the conversation
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.