[AccessD] Can't find Query

[Bob Heygood]

Ah
Maybe 
The object in the design view that does not appear in the nav pane is
"qryFFActrptA"
The SQL of the query is:
SELECT qryFFActrptA.*, C_TypeOfPlacemt.TypeOfPlacemt, C_Status.Status AS
DtlStatus

No, that's the opposite.........

Thanks



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
McGillivray, Don
Sent: Thursday, November 12, 2015 8:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Can't find Query

Hi Bob,

Check the SQL behind the query.  It's possible that the "query" showing in
the design view is really embedded SQL with an alias.  

Something like:

SELECT qryFooBar.* FROM (SELECT MyTable.* FROM MyTable WHERE
MyTable.MyColumn = 'FooBar') as qryFooBar;

In the design view this will appear as a table called "qryFooBar", but that
query won't exist among your defined queries in the DB container.

Don

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob
Heygood
Sent: Wednesday, November 11, 2015 9:19 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Can't find Query

Hello to the List,
I am trying to troubleshoot a query that returns an error "Record Deleted".
When viewing in design view, I see the source of the query is another query
and some tables.
BUT, when looking at the Nav pane, I can't find the source query I see in
the design view. IOW it seems like it is hidden.
Though when I check if "hidden" objects can be viewed, the option is set to
view them.
Is it possible that someone deleted it ?
Where is it?

TIA
Bob


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com