Is there a way to change the default size of the panes in QBE? I'm wasting
tons of time having to drag the boundries of the panes down to make room
before enlarging tables placed in the tables pane.

Thanks.

Jack Hudson

Hi, Jack.

> Is there a way to change the default size of the panes in QBE?

Not built into Access. Feel free to use the Windows API to write your own
routine to change the QBE grid.

> I'm wasting tons of time having to drag the boundries of the panes down to
> make room before enlarging tables placed in the tables pane.

Use the QBE grid to get you started with the tables and their relationships
and then switch to SQL View and copy/paste the column names wherever you
need them. If that doesn't save you time, then you're already using the
most efficient built-in method for writing queries.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Jack Hudson" <(E-Mail Removed)> wrote in message
news:PrbOh.434$(E-Mail Removed)...
> Is there a way to change the default size of the panes in QBE? I'm
> wasting tons of time having to drag the boundries of the panes down to
> make room before enlarging tables placed in the tables pane.
>
> Thanks.
>
> Jack Hudson
>

Thanks for the tip.

However, I've found the fastest way is to double click the field name from
the table field list. But to expose a larger field list necessitates
expanding the size of the table pane which first requires expanding the QBE
window downward. Simply changing the default pane coordinates should do the
job. But has anyone determined how to do that?

Has someone already written a VBA Windows API routine to reset the
window/panes?

Again thanks for the SQL view tip.

Regards, Jack



"'69 Camaro" <(E-Mail Removed)_SPAM> wrote in
message news:(E-Mail Removed)...
> Hi, Jack.
>
>> Is there a way to change the default size of the panes in QBE?
>
> Not built into Access. Feel free to use the Windows API to write your own
> routine to change the QBE grid.
>
>> I'm wasting tons of time having to drag the boundries of the panes down
>> to make room before enlarging tables placed in the tables pane.
>
> Use the QBE grid to get you started with the tables and their
> relationships and then switch to SQL View and copy/paste the column names
> wherever you need them. If that doesn't save you time, then you're
> already using the most efficient built-in method for writing queries.
>
> HTH.
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
> info.
>
>
> "Jack Hudson" <(E-Mail Removed)> wrote in message
> news:PrbOh.434$(E-Mail Removed)...
>> Is there a way to change the default size of the panes in QBE? I'm
>> wasting tons of time having to drag the boundries of the panes down to
>> make room before enlarging tables placed in the tables pane.
>>
>> Thanks.
>>
>> Jack Hudson
>>
>
>

Hi, Jack.

> Simply changing the default pane coordinates should do the job. But has
> anyone determined how to do that?

I'm sure someone has, but no one has posted the code for it to my knowledge.

> Has someone already written a VBA Windows API routine to reset the
> window/panes?

It's doubtful that anyone would go to the trouble unless someone else were
paying for it. Think about it. Is this something you'd pay hundreds of
dollars for? Not likely.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Jack Hudson" <(E-Mail Removed)> wrote in message
newsAcOh.1424$(E-Mail Removed)...
> Thanks for the tip.
>
> However, I've found the fastest way is to double click the field name from
> the table field list. But to expose a larger field list necessitates
> expanding the size of the table pane which first requires expanding the
> QBE window downward. Simply changing the default pane coordinates should
> do the job. But has anyone determined how to do that?
>
> Has someone already written a VBA Windows API routine to reset the
> window/panes?
>
> Again thanks for the SQL view tip.
>
> Regards, Jack
>
>
>
> "'69 Camaro" <(E-Mail Removed)_SPAM> wrote
> in message news:(E-Mail Removed)...
>> Hi, Jack.
>>
>>> Is there a way to change the default size of the panes in QBE?
>>
>> Not built into Access. Feel free to use the Windows API to write your
>> own routine to change the QBE grid.
>>
>>> I'm wasting tons of time having to drag the boundries of the panes down
>>> to make room before enlarging tables placed in the tables pane.
>>
>> Use the QBE grid to get you started with the tables and their
>> relationships and then switch to SQL View and copy/paste the column names
>> wherever you need them. If that doesn't save you time, then you're
>> already using the most efficient built-in method for writing queries.
>>
>> HTH.
>> Gunny
>>
>> See http://www.QBuilt.com for all your database needs.
>> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
>> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
>> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
>> info.
>>
>>
>> "Jack Hudson" <(E-Mail Removed)> wrote in message
>> news:PrbOh.434$(E-Mail Removed)...
>>> Is there a way to change the default size of the panes in QBE? I'm
>>> wasting tons of time having to drag the boundries of the panes down to
>>> make room before enlarging tables placed in the tables pane.
>>>
>>> Thanks.
>>>
>>> Jack Hudson
>>>
>>
>>
>
>

Thanks for your followup.

I could probably develop a viable business case for such functionality.

Regards, Jack

"'69 Camaro" <(E-Mail Removed)_SPAM> wrote in
message news:%(E-Mail Removed)...
> Hi, Jack.
>
>> Simply changing the default pane coordinates should do the job. But has
>> anyone determined how to do that?
>
> I'm sure someone has, but no one has posted the code for it to my
> knowledge.
>
>> Has someone already written a VBA Windows API routine to reset the
>> window/panes?
>
> It's doubtful that anyone would go to the trouble unless someone else were
> paying for it. Think about it. Is this something you'd pay hundreds of
> dollars for? Not likely.
>
> HTH.
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
> info.
>
>
> "Jack Hudson" <(E-Mail Removed)> wrote in message
> newsAcOh.1424$(E-Mail Removed)...
>> Thanks for the tip.
>>
>> However, I've found the fastest way is to double click the field name
>> from the table field list. But to expose a larger field list
>> necessitates expanding the size of the table pane which first requires
>> expanding the QBE window downward. Simply changing the default pane
>> coordinates should do the job. But has anyone determined how to do that?
>>
>> Has someone already written a VBA Windows API routine to reset the
>> window/panes?
>>
>> Again thanks for the SQL view tip.
>>
>> Regards, Jack
>>
>>
>>
>> "'69 Camaro" <(E-Mail Removed)_SPAM> wrote
>> in message news:(E-Mail Removed)...
>>> Hi, Jack.
>>>
>>>> Is there a way to change the default size of the panes in QBE?
>>>
>>> Not built into Access. Feel free to use the Windows API to write your
>>> own routine to change the QBE grid.
>>>
>>>> I'm wasting tons of time having to drag the boundries of the panes down
>>>> to make room before enlarging tables placed in the tables pane.
>>>
>>> Use the QBE grid to get you started with the tables and their
>>> relationships and then switch to SQL View and copy/paste the column
>>> names wherever you need them. If that doesn't save you time, then
>>> you're already using the most efficient built-in method for writing
>>> queries.
>>>
>>> HTH.
>>> Gunny
>>>
>>> See http://www.QBuilt.com for all your database needs.
>>> See http://www.Access.QBuilt.com for Microsoft Access tips and
>>> tutorials.
>>> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
>>> http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
>>> info.
>>>
>>>
>>> "Jack Hudson" <(E-Mail Removed)> wrote in message
>>> news:PrbOh.434$(E-Mail Removed)...
>>>> Is there a way to change the default size of the panes in QBE? I'm
>>>> wasting tons of time having to drag the boundries of the panes down to
>>>> make room before enlarging tables placed in the tables pane.
>>>>
>>>> Thanks.
>>>>
>>>> Jack Hudson
>>>>
>>>
>>>
>>
>>
>
>

Jack Hudson wrote:
> Thanks for your followup.
>
> I could probably develop a viable business case for such
> functionality.

Since the field lists all have scrollbars why would you need to re-size the
panes at all? I almost never do. I usually just use the drop-down list in
the grid for field names since that auto-expands as you type.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com