Table minimised in query builder

George-Bowyer

Registered User.
Local time
Today, 23:06
Joined
Dec 21, 2012
Messages
178
One of my tables has "disappeared" in the query builder.

You can see the link going to the table and you can see the yellow highlight of the table being selected, but it seems to be reduced in width to zero, so I can't grab it to move it out to the right.

Anyone got any suggestions, please? I'd rather not have to rewrite the entire query...

Thanks
 

Attachments

  • 1643655551450.png
    1643655551450.png
    18 KB · Views: 173
Minimize the navigation wndow?
 
Close the navigation window, i.e click the << and maximize the query design view.
 
As it is a query.
Switch to SQL view and copy the code.
Open a new query window and paste in SQL view, now switch to Design view. rearrange as needed.
Save it, delete the old one and rename new to old name.
 
Thanks, Gasman.

That worked as a workaround the problem. The new query had the right layout.

Out of interest, however, I'd still like to know how to solve the original problem.

(And how it happened - I didn't do it...)

Thanks,

George
 
TBH I do not know. I first tested it with the DB relationships, and when I moved a table off to the left as you have it, could not get it back?
Fortunately for you, yours was a query relationship. :)
 
there is a 'bug' of sorts.. If you reduce the width of the table as much as possible, regardless of where it is in the GUI window, it would appear that you cannot then widen it again from the right hand side, you have to use the left hand side assuming it is visible and has enough space to drag it left. In 2010 if join lines are coming in from the right, they get left behind once the width is narrow enough
1643736614989.png
 
Thanks, Gasman.

That worked as a workaround the problem. The new query had the right layout.

Out of interest, however, I'd still like to know how to solve the original problem.

(And how it happened - I didn't do it...)

Thanks,
Did you try my suggestion?
 

Users who are viewing this thread

Back
Top Bottom