I can't locate the queries

[c918768]

I have an access app that also links to a back end access database. I have been trying to locate the queries that are called in the vb code that is part of the Access frontend app. I can't find them in either the Access frontend or the back end database. What might I be doing wrong. Is there something that I need to turn on in order to see the queries? Here is one of the calls to the queries. DoCmd.OpenQuery ("qryUpdateBE")

[madpiet]

Weird. Are they hidden?
One way to see the query names is to use DAO and loop over the queries collection and print out the names etc

dim i as integer
for i = 0 to Currentdb.Querydefs.Count - 1
debug.print Currentdb.Querydefs(i).Name
debug.print CurrentDb.Querydefs(i).SQL
debug.print /* blank line */
next i

You'd have to copy & paste that to a new module and run it. There could a be a bunch but they're just hidden.

[CJ_London]

Another thing to check. Go to file>options>current database > navigation options and make sure the shown hidden objects option is ticked

[madpiet]

(But that would be too easy! LOL)

[jojowhite]

if your FE is runtime, you won't see any objects in it.

[CJ_London]

if your FE is runtime, you won't see any objects in it.

but then the OP wouldn't be able to do the following

Here is one of the calls to the queries. DoCmd.OpenQuery ("qryUpdateBE")

[June7]

You could provide files for analysis. Follow instructions at bottom of my post.

[jojowhite]

also you mentioned VBA.
if the query is built on a fly, eg:

Currentdb.CreateQueryDef("", sqlString)

or by using Currentdb.OpenRecordset(sqlString), then
the Query won't be listed on the navigation pane.

[c918768]

The Navigation Pane was not turned on. Thanks for sending me to the options, I noticed it from there and turned it on. I found the missing queries.

[June7]

Then everything should have been missing, but you didn't mention that.