We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

can't see my design query grid

printmedia
printmedia asked
on
Medium Priority
519 Views
Last Modified: 2012-06-27
hi everyone,

I have a small problem, I can't see my query design grid for a specific query, I already tried scrolling down the page, but still no luck. I have never experienced this before.  can anyone help?


--

Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
Is the query possibly in SQL view?  Try right clicking and selecting design view.

Author

Commented:
no the query is in desing view.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
What are you seeing when you open the query in design view?  Just a blank window?
Commented:
Hi,

The query design window has two panes: upper pane for tables and relationships, lower pane for the grid. Just scrolling the upper pane will not bring the lower pane back into view.

You need to enlarge the query window until you see the grid at the bottom. Depending on the screen resolution of the user who last saved the query, this can be tricky.

If all else fails, switch to SQL view, then copy and paste the SQL into a newly created blank query. You would then have the default pane sizes.

Good luck
(°v°)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I see only the upper pane with the tables and relationships, when i scroll down i see a blank.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
Have you tried Harfangs idea?  You may also be able to click at the bottom of the tables/relationships pane, and drag that to a smaller size to make the grid pane visible.  The bottom of the tables pane should look distinct from the bottom of the query builder itself.
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
Is it just this one query?
Could you export it... delete it and then re-import it?
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
(That said - Markus' copy/paste the SQL is far more trivial than the way I'd recommend you do that anyway :-)

Author

Commented:
I changed the screen resolution of my computer and now it works, thanks!!!

Commented:
And you can now reduce the upper pane so that you will see the grid in low resolution the next time...
Glad it worked!
(°v°)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.