Finding missing queries

[Amy Blankenship]

I have several queries that are based on a set of queries that I can't see.
The queries based on those queries mostly work, but I can't get at them for
troubleshooting. Yes, I have the view hidden objects checkbox checked, but
I'm certain I never hid those queries. What else could cause a query not to
show in the query window?

Thanks;

Amy

 

[raskew via AccessMonster.com]

Hi Amy -

Try copying/pasting this to a new query. It may give you a fresh view of
your queries.

SELECT
A.Name
, A.Type
, B.Name1 AS Source
FROM
MSysObjects AS A
INNER JOIN
MSysQueries AS B
ON
A.Id = B.ObjectId
WHERE
(((A.Id)=.[ObjectID])
AND
((B.Expression) Is Null)
AND
((Left([Name],1))<>'~')
AND
((Left([Name1],1))<>'['))
ORDER BY
A.Name;

HTH - Bob

 

[Amy Blankenship]

Actually, the queries weren't really queries. They were just the same table
aliased several times depending on what I was doing with it. I just forgot
that, and since I knew I didn't have tables of those names I assumed they
were queries.

Hi Amy -

Try copying/pasting this to a new query. It may give you a fresh view of
your queries.

SELECT
A.Name
, A.Type
, B.Name1 AS Source
FROM
MSysObjects AS A
INNER JOIN
MSysQueries AS B
ON
A.Id = B.ObjectId
WHERE
(((A.Id)=.[ObjectID])
AND
((B.Expression) Is Null)
AND
((Left([Name],1))<>'~')
AND
((Left([Name1],1))<>'['))
ORDER BY
A.Name;

HTH - Bob

I have several queries that are based on a set of queries that I can't
see.
The queries based on those queries mostly work, but I can't get at them
for
troubleshooting. Yes, I have the view hidden objects checkbox checked,
but
I'm certain I never hid those queries. What else could cause a query not
to
show in the query window?

Thanks;

Amy

 

[raskew via AccessMonster.com]

Oops,

Hate it when that happens!

Best wishes, Bob

Actually, the queries weren't really queries. They were just the same table
aliased several times depending on what I was doing with it. I just forgot
that, and since I knew I didn't have tables of those names I assumed they
were queries.

Hi Amy -

[quoted text clipped - 37 lines]