Lost Query Design Grid

[Smilie]

I am trying to finish an Access database that someone else started. In many of the queries, the design grid is missing.

In design mode, I can see the tables and relationships being used, but the bottom portion is simply not there. I have tried scrolling to the bottom to check and see if it is just "hiding" but it is not there either.

I can view the query fine in SQL mode but it is complex and therefore time consuming to make changes this way.

Any suggestions to where my design grid is hiding????

 

[Pat Hartman]

Are you sure that you didn't just drag the separater line too far down. Try maximizing the window to see if the bottom part comes back.

 

[Smilie]

Yes, I'm sure. That was my first instinct too. I keep thinking that it MUST be down there. But, it definitely isn't.

It looks like the person who built the query may have done so in the SQL screen. Is there any reason why this would cause the design grid not to show?

 

[Brianwarnock]

Did you just look or did you slowly move your mouse to the bottom of the screen to see if it picked up the separator bar, this happened to me.

Brian

 

[Smilie]

I maximize the screen, scroll all the way to the bottom and slowly move my cursor up and down and side to side seeing if I can get it to change into the arrow with points at both ends. Nothing happens. It just remains as the regular cursor arrow.

I try to drag the mouse over the area just in case I might be able to highlight something that is not visible...but that doesn't work either.

This is totally bizarre. It really does seem like a simple solution but I just can't seem to make it work. I've been working in Access long enough to know that you can accidently squish the grid at the bottom, but I have always been able to find it again.

Since this was someone else's db, I thought maybe they did something weird that I just didn't know about.

 

[KenHigg]

Place cursor towards the bottom of the screen. Slowly move coursor down. Just before itgoes into the staus bar, the cursor shape should turn into an up/down arrow with a short horiz. line going trough it. When this cursor appears, you should be able to click and drag the design grid up...

Does this work?

 

[Smilie]

No, that doesn't work. That's what I was trying to explain in the last entry.

Anyway, I found a solution or should I say a work-around. I simply copied the sql into a new query. And then switched to design view.

I am still curious as to why this would happen, but I have found a solution.

 

[dcmorrison4526]

I've also had this happen and the way to fix it is to minimize the ribbon from the top right corner by the help icon. Then you'll be able to get that bar at the bottom that allows you to drag the window up.

 

[rgriffith1214]

This happens to me frequently, as I am managing databases created by my predecessor. Is there a colored bar under the scroll bar at the bottom of your access window with a series of dots in the center? That is the divider bar between the tables section and the design grid. If you can see that, drag it up to view the design grid. Sometimes using the arrow to show or hide the ribbon (next to the help ? in the upper right corner ) will allow the design grid to display, but not always.