Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-09
14
Medium Priority
?
520 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 1500 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 58
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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 1500 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 58
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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

688 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