Re: hidden queries

From: Sal Rosario (nodirectmail_at_cedrostec.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 19:12:16 -0400

To view all your hidden objects, follow the instruction below. Once you see
your query, right-click it, choose proporties, and unhide it. Then, reverse
the steps below if you want to hide everything else again.

1. Choose Tools...Options from the menu bar.
2. Activate the View tab.
3. Check the Hidden objects box. 

--
Regards,
Sal Rosario
Microsoft Access Database Cosultant
www.salrosario.com
"Jeanne" <jconroy@solutions-center.com> wrote in message
news:u4RW6jjLEHA.2244@tk2msftngp13.phx.gbl...
I am working in Access 97 and wanted to protect a query from being modified.
I right-clicked the query in the database window, chose Properties and
hidden.  The query became invisible.  The report based on it runs fine, but
I don't know how to unhide the query should I need to edit it.  Can someone
help, please?

Relevant Pages

  • Re: Hidden tables in query wizzard
    ... problem than being able to view hidden tables in the Query Wizard. ... not understand why you'd want to hide the Tables, Queries, or whatevers from ... hidden objects -- that is, you should have some reason for their being ... "If it is a database just developed for your own use, ...
    (comp.databases.ms-access)
  • Re: How to make all access to linked table read-only
    ... > the box next to Hidden Objects. ... >>> read only for data that comes from that query. ... Also, reports aren't ... there is no editing data that the user can do in a ...
    (comp.databases.ms-access)
  • Re: hide - unhide query
    ... > Can I unhide a query? ... > PharmTouch ... Tools + Options + View + Show Hidden objects. ...
    (microsoft.public.access.queries)
  • Re: How to make all access to linked table read-only
    ... next to Hidden Objects. ... >> that comes from that query. ... Also, reports aren't a problem, there is no ... > (but not sure how to unhide it to see it again). ...
    (comp.databases.ms-access)
  • Re: Hidden tables in query wizzard
    ... In the query desgn view, ... hidden objects -- that is, you should have some reason for their being ... "If it is a database just developed for your own use, ... few linked tables and few queries. ...
    (comp.databases.ms-access)