Help with Problem with Query Design Page Display
Posted: Sat Feb 24, 2018 11:00 am
Hi, wonder if anybody can help.
I have been having an intermittent problem with the Query Design page, which I cannot seem to resolve.
The three sections displayed (when not using SQL directly) from top down are
Results Section
Tables Relation Section
Fields Selection/Manipulation Section
On first creating a query, as expected, the Table Relations Section and Field Section display, more or less with a 50/50 size split down the screen, with a popup allowing user to select Tables or Queries, to add to the Table Relation Section.
At this stage there is a bold black line at the top of the Fields section which can be dragged up or down to increase or decrease the height of the Field display.
On running the first query, this line remains, and is still resizable, the "add tables" popup disappears, and the Results section appears at the top, this is also resizable if the user hovers over the bottom lines of this section. The middle (Table Relation) section is squeezed by the Fields and Results section. I am able to decrease the heights of both in order to better view theTables section. However, more often than not, on re-opening, for some reason, I am left with sections which cannot be resized.
Has anyone else experienced this or know a solution. I have tried all the obvious such as closing the query, closing base etc. Results appear random, sometimes it rectifies the problem, sometimes not....
I have been having an intermittent problem with the Query Design page, which I cannot seem to resolve.
The three sections displayed (when not using SQL directly) from top down are
Results Section
Tables Relation Section
Fields Selection/Manipulation Section
On first creating a query, as expected, the Table Relations Section and Field Section display, more or less with a 50/50 size split down the screen, with a popup allowing user to select Tables or Queries, to add to the Table Relation Section.
At this stage there is a bold black line at the top of the Fields section which can be dragged up or down to increase or decrease the height of the Field display.
On running the first query, this line remains, and is still resizable, the "add tables" popup disappears, and the Results section appears at the top, this is also resizable if the user hovers over the bottom lines of this section. The middle (Table Relation) section is squeezed by the Fields and Results section. I am able to decrease the heights of both in order to better view theTables section. However, more often than not, on re-opening, for some reason, I am left with sections which cannot be resized.
Has anyone else experienced this or know a solution. I have tried all the obvious such as closing the query, closing base etc. Results appear random, sometimes it rectifies the problem, sometimes not....