MS Access 2013 Object Browser, Accidently Clicked 'Hide In this Group', How to Unhide?

I wanted to cut and paste the name of a query 'qryTaxHeaders_ActiveOnly' into the logic in my Access 2013 application.  I do this by right clicking on the query and selecting 'Rename'.  I then copy the name into the program logic.  I've done this hundreds of times, maybe more.

This time I missed 'Rename' and must have clicked 'Hide in this group', which I never even knew was there, let alone had used before.

The query name disappeared.  Initially I thought I had deleted it so I re-imported from a backup.  The import was named 'qryTaxHeaders_ActiveOnly1'.  The suffix of '1' meaning the object already existed.

How do i get my hidden query to show again in the query list?
LVL 1
mlcktmguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Dale FyeCommented:
go to the "All Access Objects" at the top of the Navpane, right click, select Navigation Options.

Then check the "Show Hidden Objects" checkbox.  This should display the item greyed out, right click on it and select the UnHide option.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.