Automating MS Access

[devm01]

Hi... I've found a broader way to ask my question from a few days ago.

How can I automate the access environment, so that when I go into a
particular window access runs a script.

Here's the specific. When I design a new query and add tables, I'd like
the windows and panes to resize to show all of the tables with all of
their fields.

Any ideas anyone?

Dev

 

[John Vinson]

Hi... I've found a broader way to ask my question from a few days ago.

How can I automate the access environment, so that when I go into a
particular window access runs a script.

Here's the specific. When I design a new query and add tables, I'd like
the windows and panes to resize to show all of the tables with all of
their fields.

Any ideas anyone?

Dev

It would help if you asked questions in Access terms. Access does not
use "windows" or "panes"; it uses forms. It doesn't use scripts; it
uses Procedures in modules.

It sounds like what you want to do is to continually redesign and
restructure your tables, and have all your Forms (and Reports?)
redesigned and restructured when you do so. This is an EXTREMELY
unusual approach. Normally one would start with a properly normalized
set of tables, which will remain pretty static; you would then design
and lay out user-friendly Forms to reflect the content of these
tables.

Could you explain the context? Are you trying to create one Great
Master Form which displays all fields in all tables all at the same
time?

John W. Vinson[MVP]

 

[devm01]

John, thanks for the coaching and help... let me try again. I start up
access, open my database, select queries and then "create query in
design view". Access then prompts me to Add tables that I want in the
query. This tables appear as small icons that needed to be expanded to
see the field names. I also have to drag down the middle bar to make
enough room to see the tables and field names.

I'd like Access to expand the table area and automatically expand the
table "definitions", to make it easier to get straight to draging and
dropping fields vs. resizing everything before I can start.

Do let me know if there's an easier way...

Thanks, Dev

 

[John Vinson]

John, thanks for the coaching and help... let me try again. I start up
access, open my database, select queries and then "create query in
design view". Access then prompts me to Add tables that I want in the
query. This tables appear as small icons that needed to be expanded to
see the field names. I also have to drag down the middle bar to make
enough room to see the tables and field names.

I'd like Access to expand the table area and automatically expand the
table "definitions", to make it easier to get straight to draging and
dropping fields vs. resizing everything before I can start.

Do let me know if there's an easier way...

Thanks, Dev

Well... one possibility is that you may have some awfully large
tables. I've had a few tables so big that I had to drag down the
window to see all the fields, but these are the exception, not the
rule.

You can scroll within each table icon; you can type the fieldnames in
the Field cells, and they'll autocomplete.

However, I see what you'ld like to do, but alas, I know of no way to
automate this aspect of the display.

John W. Vinson[MVP]

 

[devm01]

Is there a different way to design a query that's as easy as this, with
the flexibility almost to the level of writing sql without the
verbosity?