Default pane size in QBE.

[Jack Hudson]

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

 

['69 Camaro]

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/expert_contributors2.html for contact
info.

 

[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]

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/expert_contributors2.html for contact
info.

 

[Jack Hudson]

Thanks for your followup.

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

Regards, Jack

 

[Rick Brandt]

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.