• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

Why can't I see the entire design view in my qry

All I can see are the tables and relationships.  The criteria section is missing and there's no scroll bar at the bottom and the one at the side is unending.  And they view of the tables seems bigger.
0
Ange1ia
Asked:
Ange1ia
  • 5
  • 4
  • 3
  • +1
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
in the design view of the query, grab the horizontal line that separates the table display part and the Grid lines and drag upward.
0
 
Ange1iaAuthor Commented:
It won't let me.  I've gone to the bottom and even tried dragging the scroll bar at the side down down down and it's never ending.   And there's no scroll bar at the bottom to move to the right because there's a table out there to the right I can't see.  It's like it's blown up or something.  I was looking for something to take it down to like 50% but can't find anything like that.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<< I was looking for something to take it down to like 50% but can't find anything like that. >>

  Select the query window and then grab the upper left corner (should get a double headed arrow) and drage to towards the lower right.  Then move the window back up to the upper left and repeat until you can see the full window.

  At that point, you should be able to scroll and move the splitter bar as cap suggested.

  Failing that, a screen shot would be helpful.

JimD.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Rey Obrero (Capricorn1)Commented:
upload a copy of the db..
0
 
Ange1iaAuthor Commented:
Here's a picture of what I'm dealing with.  See no gridlines for  criteria area and no scroll bar at the bottom for moving right and left.
Query-Issue-3-9-11.doc
0
 
Rey Obrero (Capricorn1)Commented:
click on the restore window button  (upper right corner, next to the X button)
0
 
Jeffrey CoachmanMIS LiasonCommented:
...and if you "Restore down" the window (Click the little square in the upper right), ... do the scroll bars appear?
Try then
0
 
Jeffrey CoachmanMIS LiasonCommented:
If not then try:
Running the compact/repair utility.

If this does not work then just use brute force:
Export the "Rogue" table to another DB.
Then delete it from the main db.
Then re-import it, and re-link it.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  With the right scroll bar, scroll all the way to the bottom.

  Right above the status bar (where it says "Ready") you should see a thick line.  If you hover over it, you should see a splitter icon (line with a double arrow).  Click and drag up when you see that.

  As for the table off to the right, try the restore option as Jeff suggested or hitting the database window button, which should cause the query window to reformat.

JimD.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Jim, Ange1ia

Sorry, I thought this was an issue with the "Database" window...
:-(
So ignore my post for the most part...


Anyway sorry for interrupting...

Jeff
0
 
Ange1iaAuthor Commented:
I just redid it.  I got tired of trying to fix it.  Thanks anyway.

Angie
0
 
Ange1iaAuthor Commented:
There is no bottom to scroll to.  That's why I just re did the qry.  I don't know what happened to it.
0
 
Jeffrey CoachmanMIS LiasonCommented:
FWIW, something similar happened to me in the relationship window.

I redid it as well...
0
 
Ange1iaAuthor Commented:
I just redid the query.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now