Solved

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

Posted on 2011-03-09
14
510 Views
Last Modified: 2013-11-29
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
Comment
Question by:Ange1ia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 3
  • +1
14 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 35083537
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
 

Author Comment

by:Ange1ia
ID: 35083629
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
 
LVL 57
ID: 35083725
<< 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 500 total points
ID: 35083734
upload a copy of the db..
0
 

Author Comment

by:Ange1ia
ID: 35083750
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35083826
click on the restore window button  (upper right corner, next to the X button)
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35083885
...and if you "Restore down" the window (Click the little square in the upper right), ... do the scroll bars appear?
Try then
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35084000
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
 
LVL 57
ID: 35084352

  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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35084775
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
 

Author Comment

by:Ange1ia
ID: 35085669
I just redid it.  I got tired of trying to fix it.  Thanks anyway.

Angie
0
 

Author Comment

by:Ange1ia
ID: 35085730
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35086492
FWIW, something similar happened to me in the relationship window.

I redid it as well...
0
 

Author Closing Comment

by:Ange1ia
ID: 35087389
I just redid the query.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question