Solved

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

Posted on 2011-03-09
14
508 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
  • 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

778 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