Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query design grid missing (Access 2003 SP1)

    I have an existing query that the design grid is missing. When I open the query in design mode, I can see the tables and their relationships, but I cannot see (or get to) the design grid to view fields used and calculations used.

    Any suggestions on how to retrieve the design grid?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: query design grid missing (Access 2003 SP1)

    The line that divides the design grid from the upper part (with the tables) can be dragged up and down. Can you see this line if you maximize the query? If so, drag it upwards to just below the tables. If not, try the following:
    - Select View | SQL.
    - Copy the SQL text to the clipboard (Ctrl+C)
    - Create a new query in design view, don't add any tables.
    - Select View | SQL.
    - Delete the text (SELECT, then paste (Ctrl+V).
    - Switch to design view.
    - You should now see the design grid (you may have to make the window larger).
    If it works, rename the old query, then save the new one with the original name.

  3. #3
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query design grid missing (Access 2003 SP1)

    When maximized the movable line was not available.

    I did try all the other steps listed, and I am now able to view the design grid.

    Thank you very much for the quick response.

Posting Permissions

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