If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Best Fit" table windows?
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 |
#2
|
|||
|
|||
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 www.fmsinc.com/consulting "Mark" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
Office 97 Pro Upgrade - Install on new computer | John | General Discussions | 2 | June 1st, 2005 04:58 AM |
Unable to edit records in a form or query | Merlin | Using Forms | 7 | May 10th, 2005 02:00 PM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |