Cannot see my queries in Design View !

Question

I opened a database and right clicked on a query and chose 'Design View'. Nothing appears.

I know there is a query there and I can run it, but I cannot see it in design view.

I suspect it's there but off the screen. However, there are no scroll bars, neither vertical or horizontal.

How do I see my queries?

Answer 1

Hi,

Can you post a screenshot?

When you say you can "run" the query, what do you see?

If it's a SELECT query, can you click on Design View from the View Ribbon?

Answer 2

I just noticed in front of the query name is a large plus sign and then a large exclamation mark.

When I open the query, it says "You are about to run an append query", which I do not want to do.

I just need to look at the SQL of the query.

This is an old version though so I'm thinking the query may be referring to something that no longer exists.

Answer 3

Hi,

If you need to know the SQL statement for this query, and you can't use Design View, you could try the following in the Immediate Window:

?CurrentDb.QueryDefs("QueryName").SQL

Hope it helps...