Help - TIA ... query design grid is missing ...

[Beta]

TIA ...

Sometimes, when I copy access mdb that I use at the office in my
laptop, and I look at the queries in the query desihgn grid, all I
could see is the upper portion where the tables and property window
are ... the bottom portion where the query grid would be is gone !

Any ideas ? I know it did not diassapear, it's just that I cannot see
the grid - something to do with resolutions of the two different
machines that had the mdb ?

TIA

jim

 

[Steve Schapel]

Jim,

I have never experienced like this before. But what happens if you
increase the height of the query design window, by putting your mouse
pointer at the bottom of the window, to get the double-headed resize
pointer, and then drag down?

 

[fredg]

TIA ...

Sometimes, when I copy access mdb that I use at the office in my
laptop, and I look at the queries in the query desihgn grid, all I
could see is the upper portion where the tables and property window
are ... the bottom portion where the query grid would be is gone !

Any ideas ? I know it did not diassapear, it's just that I cannot see
the grid - something to do with resolutions of the two different
machines that had the mdb ?

TIA

jim

Probably caused by having the 2 computers on different screen
resolutions.
I had a similar problem with another non-Access application, where I
couldn't see a pair of command buttons at the bottom of the form, and
the form was not resizable.
Increase the resolution on the computer that has this problem.
Open the query in design view. If you can now see the grid (or any
part of the grid), move it upward towards the upper panel as much as
you can.
Save the query.
Go back and reset the screen resolution to where it was.
Open the query again and see if that has helped find the lower panel.

 

[Jim]

Hello Steve ...
Many thanks for your quick response ...

I have attached one of the queries - created this one on a desktop at
my office ... copied the mdb database and continued working on it at
home in my laptop ...

as you can see in attached file, only the UPPER portion of the query
design window shows ... the left-to-right scroll bar below the tables
area (where the query design grid starts) disappeared and everything
below the scroll bars, including of course, the design grid !!! I know
that grid is somewhere there because the query works ... But how do I
get it back so I could modify the darn query ?

I was able to "fix" this one time toggling with the minimize and
maximize button of the query window and the application window ...

Help ...

Many Thanks
jim



+++++++++++++++++++++++++++++++++++++++++++++++++

Jim,

I have never experienced like this before. But what happens if you
increase the height of the query design window, by putting your mouse
pointer at the bottom of the window, to get the double-headed resize
pointer, and then drag down?

+++++++++++++++++++++++++++++++++++++++++++++++++

 

[Jim]

Fred ...
You are right ... I increased my reso and I was able to see the design
grid ... You diagnosed it great and your cure was perfect ...

I love this newsgroup - has helped me over the years ... I hope to be
able to contribute one of these days ...

Steve, Thank You ... and Steve Thank You ...

jim

 

[Jim]

Many, Many thanks to Steve and Fred ... you guys are great !

jim

 

[Steve Schapel]

Yep, Fred hit the nail on the head, Jim. Glad you've got it sorted.