Results 1 to 6 of 6
  1. #1
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Unanswered: Query by Design screen

    Hi, has anyone run into this situation before? I've opened a query in the design mode and the tables are displayed but you can't scroll down far enough to get to the rows and columns of the fields that have been selected. I can't seem to find a way to get to the bottom of the screen to change anything. Any help is greatly appreciated.

    Thanx, Stu
    --If its free, take it for what its worth!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    not really.. but hten again I tend to write SQL in the SQL view, nit use the query designer unless Im being really idle.

    if you knwo the columns you want then 'just' add them as required in the SQL view

    switch to SQL view
    you should see soemthing like
    select my, column, list from mytable
    where thiscolumn=blah
    order by another,column,list
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Thanx

    Thanx, I can do that part with no problem, it is just something now that is ticking me off. Sort of another man vs. machine thing that I want to win!
    --If its free, take it for what its worth!

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Use the vertical scroll bars to the right or re-adjust the height (between the tables and bottom portion). You can re-adjust the height by clicking on the line separating the top portion/bottom portion (and holding down the left-button when you see the line with up/down arrows to adjust height) and then moving up or down (similar in all Office products where you want to adjust the height of something).
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If you really want to win, copy the SQL, delete the query, create a new query and paste the SQL. Victory!!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    Victory

    Everyone thanks for the tips!

    PKStormy: I had already done everything you suggested, all of the standard Office things. The problem was that even with the window maximized I could not scroll down far enough to get to the bottom portion. I have only seen this a couple of times and never did fix it.

    StarTrekker: Copying the SQL worked just fine. I was going to try that before but I was being lazy because a sub query in this one had become invalid so the SQL wasn't correct and so it wouldn't let me into the design mode. I had to go back in and import an older, valid copy of the query and then copy the SQL into a new query and then go into the design mode.

    Now all is good!

    Thanks everyone!
    --If its free, take it for what its worth!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •