Find a Query

[Guest]

I just inherited an ACCESS-97 db at work. Since there is zero program
documentation, that's my first step. However, when I go into Design mode on
one of the Macro's, it does an OpenQuery on a query that I cannot find in the
Query area. Note, the query name starts with a tilde (~). Does the ~ mean
anything different? All of the other queries that are not named in this
manner all reside in the query area.

Any advice would be greatly appreciated!!!

Tom

 

[Van T. Dinh]

It may be hidden...

Use the Menu command Tools / Otions ... / View tab / Show pane and check the
"Hidden objects" option and see if it shows up ...

 

[Richard Williams]

I just inherited an ACCESS-97 db at work. Since there is zero program
documentation, that's my first step. However, when I go into Design mode
on
one of the Macro's, it does an OpenQuery on a query that I cannot find in
the
Query area. Note, the query name starts with a tilde (~). Does the ~
mean
anything different? All of the other queries that are not named in this
manner all reside in the query area.

Any advice would be greatly appreciated!!!

Tom

It may be hidden. To show hidden objects go to the Tools menu and select
Options. On the View tab there is a check box to show hidden objects. This
is how it is in Access 2000 and I'm assuming it's the same in Access 97.

 

[Guest]

Rich - that worked! Thank you very much for providing me the answer to this!

 

[Guest]

Van - that worked! Thank you very much for providing me the answer to this!

 

[Van T. Dinh]

You're welcome ... Glad to help ...