I always set db for Overlapping Windows instead of Tabbed Documents.
Try reducing size of the grid area by dragging the splitter bar down.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you for your response.
I had already tried reducing size of grid but it did not work.
I wouldn't call that the ER window; to me what you have there is just the query design UI. Not sure what overlapping windows has to do with it either. You have a lot of wasted space below the query design grid, so just drag the border between the criteria grid and the tables window down? Or use the vertical scroll bar?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I wouldn't call that the ER window; to me what you have there is just the query design UI. Not sure what overlapping windows has to do with it either. You have a lot of wasted space below the query design grid, so just drag the border between the criteria grid and the tables window down? Or use the vertical scroll bar?
Oops. I see that was already suggested (as a splitter bar).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I find it is easier to view multiple objects with Overlapping Windows.
Unfortunately, cannot replicate issue. I cannot drag a table high enough to cut off that much.
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Whilst also prefer overlapping windows, that has absolutely nothing to do with this issue.
Unfortunately dragging the splitter bar down won't help either.
If you have Access 365, you can now 'lasso' one or more tables and drag them downwards.
Hello,
Thank you for your reply and sorry it took me so long to respond.
I have no idea what it means to 'lasso' a table. I thought my problem may have been simple to resolve but apparently not.
At this point I am going to reenter the query and hope that solves the problem.
Thanks again.
I think the lasso thing pertains to a new feature in table relationships design window but not a query. Not 100% sure about the query. If moving the bar down didn't expand the upper window and allow you to scroll, then I think the fix for this is to switch to sql view and open a new query in sql view and paste in your sql and save it. You likely caused this by developing or modifying this query in design view on another pc with a different resolution, thus it won't display properly now. I suppose you could fudge the monitor settings you're using at this point to be able to move things around, but copying the sql would make more sense.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Lassooing refers to holding the left mouse button down whilst you select one or more items.
The feature is used in numerous places in Access and other Office programs but has only recently been added to the relationships window in A365.
In fact it also works in the query designer window.
The following is from the What's New feature in A365
How do you do that if a table is out of bounds and the window won't scroll up to show it? If you're saying it works anyway, I can't even try it because I have nothing with that issue, which I imagine arises because user switches to a pc with a different screen resolution (and I'm not going to try to mess up something on purpose!).holding the left mouse button down whilst you select one or more items.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Allow me to deliberately mess things up and then fix them.
There should be 3 system tables here but I've moved one completely off screen and another partly off screen
Now I can select all objects by lassoing them - even if completely off screen
The borders are shaded yellow to indicate they have been selected
Now I can move all of them down together
Of course that is the exact reverse of what I did originally to deliberately mess things up
It won't let you move all the tables off the top of the screen completely so it is always possible to recover them
Clicking any one table or outside the selection will disable the grouping
Unfortunately, I was aware of that but I thought we were talking about a query. Did you look at the attachment image from the first post? Or are you saying this applies to the query design window also even though you've demonstrated it for the relationships window?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
@Micron, see Colin's comment in post 10.
"In fact it also works in the query designer window."
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.