"Best Fit" table windows?

M

Mark

Using ACC2000.

The more I think about this, the more I think it can't be done, but I'll ask
anyway.

I have a bunch of queries that need to be updated, which requires adding
another outer join. In the GUI, the tables in the query are at a "default"
height, covering the field I want to join. So, I have to drag down the table
window to uncover that field. Not a big deal, but it is tedious. Is there an
option in Access where it will automatically increase the # of fields shown
in a table to [n] for all the queries in the database?

Thanks!
-Mark
 
M

[MVP] S.Clark

Switch the SQL view and insert the text. Skip the GUI.

FROM tableA INNER JOIN tableB on TableA.field = TableB.field

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top