In Query Design, No queries in add new table/query dialog box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have queries in my database. When i go into query design , +add table, no
queries are in the queries tab of the show table dialog box. Has anyone seen
this?

If i create a simple query eg. 'select * from table' it does appear? but all
my other query no longer show up.
I have compacted and repared the database and tried import everything into a
new database. Even pasting the SQL into a new query, dosen't work.i can't use
this new query in another queries design. This is a major bug!

help
mike!
 
Hi
I have queries in my database. When i go into query design , +add table, no
queries are in the queries tab of the show table dialog box. Has anyone seen
this?

If i create a simple query eg. 'select * from table' it does appear? but all
my other query no longer show up.
Click to expand...

Action queries - MakeTable, Append, Update, Delete queries - don't
return any records and therefore cannot be used from this box. Are the
queries you're missing perhaps in this category?

John W. Vinson[MVP]
 
Hi thanks!

just shoot me! must have left my brian at home!
Click to expand...

<g> Well, I hope Brian was taking it easy and having a good time! Glad
to find a simple solution.

John W. Vinson[MVP]
 
Back
Top