Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    DenisM is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Location
    Sleaford Lincs
    Posts
    29

    Cannot see the top half of the relationship diagram

    Hello,
    Can somebody help?
    I recently created a query. Today I wanted to make changes but I cannot access the top half of the ER diagram.
    See attached.


    Thank you.ERD.pdfERD.pdf

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  3. #3
    DenisM is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Location
    Sleaford Lincs
    Posts
    29
    Thank you for your response.
    I had already tried reducing size of grid but it did not work.

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    DenisM is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Location
    Sleaford Lincs
    Posts
    29
    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.

  9. #9
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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

    Click image for larger version. 

Name:	Capture.PNG 
Views:	13 
Size:	41.2 KB 
ID:	42082
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  11. #11
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    holding the left mouse button down whilst you select one or more items.
    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!).
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  12. #12
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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

    Click image for larger version. 

Name:	Capture.PNG 
Views:	12 
Size:	6.2 KB 
ID:	42083

    Now I can select all objects by lassoing them - even if completely off screen
    Click image for larger version. 

Name:	Capture2.PNG 
Views:	12 
Size:	6.4 KB 
ID:	42084
    The borders are shaded yellow to indicate they have been selected

    Now I can move all of them down together

    Click image for larger version. 

Name:	Capture3.PNG 
Views:	12 
Size:	12.5 KB 
ID:	42085

    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
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  13. #13
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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.

  14. #14
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    @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.

  15. #15
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Thanks June
    Yes. As I said in post #10 it works in exactly the same way in both the query designer & relationships windows

    Click image for larger version. 

Name:	Capture0.PNG 
Views:	12 
Size:	10.0 KB 
ID:	42086

    Click image for larger version. 

Name:	Capture4.PNG 
Views:	12 
Size:	17.3 KB 
ID:	42087
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-25-2016, 12:44 PM
  2. Entity Relationship diagram
    By hickie182 in forum Database Design
    Replies: 3
    Last Post: 12-15-2013, 02:19 PM
  3. Relationship diagram
    By tsvetkovdimitar in forum Sample Databases
    Replies: 1
    Last Post: 11-16-2013, 06:24 PM
  4. Replies: 1
    Last Post: 08-17-2012, 04:50 PM
  5. Replies: 1
    Last Post: 11-09-2011, 12:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums