Saving the asthetics

M

mcescher

Hi All,

So, when I'm working in Access, and create a new table or query,
Access assumes that the window should set up for like 20 columns and 8
rows of data (short and fat). But sometimes a table I create only has
two or three columns, but a lot of rows. Saving the table tall and
skinny doesn't save the table like that. The next time I open it,
it's formatted short and fat again.

Is there a way to save the asthetics of the table?

Access 2002 SP3, Windows XP Pro

Thanks for your time,
Chris M.
 
J

Jeff Boyce

Chris

I can't tell from your description, but it sounds like you're talking about
the design view, not the table (or query) itself.

After all, if a query only has three columns, running the query only
generates three columns...

Or am I missing something?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeanette Cunningham

Chris,
If you create a new table using create by entering data you will get a large
number of columns.
If you create a new table by using create in design view, you get only the
fields you set up.
With a table in datasheet view, drag each column to the width you want.
When you close the table, access will ask if you want to save design
changes.
Answer yes.

Jeanette Cunningham
 
M

mcescher

Chris,
If you create a new table using create by entering data you will get a large
number of columns.
If you create a new table by using create in design view, you get only the
fields you set up.
With a table in datasheet view, drag each column to the width you want.
When you close the table, access will ask if you want to save design
changes.
Answer yes.

Jeanette Cunningham










- Show quoted text -
Click to expand...

Thank you both for your responses, but let me clarify my question.

Some time ago, I created a table of three columns (save and exit), and
now I'm entering data. I move the window to the upper left portion of
my screen, and resize it to only show three colums wide, but 40 rows
of data. (tall and skinny) If I close the table and re-open it, it
appears (for example) in the middle of the screen, and only showing
about eight rows (short and fat). Is there a way to save the location
and size of the table after I've moved and resized it?

Thanks again,
Chris M.
 
J

John W. Vinson

Is there a way to save the location
and size of the table after I've moved and resized it?
Click to expand...

Avoid this (and many other) problem: use a Form for interaction with data.

Table datasheets are designed for storing data, not for data entry or
reporting.

You can use a datasheet view form, or a Continuous form to see multiple
records.
 
M

mcescher

Avoid this (and many other) problem: use a Form for interaction with data.

Table datasheets are designed for storing data, not for data entry or
reporting.

You can use a datasheet view form, or a Continuous form to see multiple
records.
Click to expand...

Ok, I'm still being as clear as mud. This is only for the design
process.

As I'm building a database, and I have a query that I'm looking at
spread across the top of the screen. (The object I'm working on
doesn't really matter) I move the query to the bottom right corner of
the screen. I would like to save the query so that the next time I
open it, it appears in the bottom right corner rather than spread
across the top of the screen.

This really doesn't have anything to do with the user interface that
I'm designing, or interaction with the data. I just want to be able
to arrange the windows the way I like during the development process.

Thanks again,
Chris M.
 
J

Jeanette Cunningham

Chris,
to arrange open database objects such as tables and queries, on the top menu
select Window, then select a tiling option such as vertical, horizontal etc.
This is the only way to do what you want with tables and queries.
Forms can be coded to open at specific places on the screen, but not tables
and queries.

Jeanette Cunningham

Avoid this (and many other) problem: use a Form for interaction with data.

Table datasheets are designed for storing data, not for data entry or
reporting.

You can use a datasheet view form, or a Continuous form to see multiple
records.
Click to expand...

Ok, I'm still being as clear as mud. This is only for the design
process.

As I'm building a database, and I have a query that I'm looking at
spread across the top of the screen. (The object I'm working on
doesn't really matter) I move the query to the bottom right corner of
the screen. I would like to save the query so that the next time I
open it, it appears in the bottom right corner rather than spread
across the top of the screen.

This really doesn't have anything to do with the user interface that
I'm designing, or interaction with the data. I just want to be able
to arrange the windows the way I like during the development process.

Thanks again,
Chris M.
 
M

mcescher

Chris,
to arrange open database objects such as tables and queries, on the top menu
select Window, then select a tiling option such as vertical, horizontal etc.
This is the only way to do what you want with tables and queries.
Forms can be coded to open at specific places on the screen, but not tables
and queries.

Jeanette Cunningham







Ok, I'm still being as clear as mud.  This is only for the design
process.

As I'm building a database, and I have a query that I'm looking at
spread across the top of the screen.  (The object I'm working on
doesn't really matter)  I move the query to the bottom right corner of
the screen.  I would like to save the query so that the next time I
open it, it appears in the bottom right corner rather than spread
across the top of the screen.

This really doesn't have anything to do with the user interface that
I'm designing, or interaction with the data.  I just want to be able
to arrange the windows the way I like during the development process.

Thanks again,
Chris M.- Hide quoted text -

- Show quoted text -
Click to expand...

Ok, after I've arranged them, is there a way to save that "layout"?

Thanks again to all that have contributed to this simple yet difficult
question.

Chris M.
 
J

Jeanette Cunningham

Chris,
no, as far as I know, there is no way to save the layout.
I am completely used to setting up the layout manually when I open a
database, after a few years of using Access.

Jeanette Cunningham

Chris,
to arrange open database objects such as tables and queries, on the top
menu
select Window, then select a tiling option such as vertical, horizontal
etc.
This is the only way to do what you want with tables and queries.
Forms can be coded to open at specific places on the screen, but not
tables
and queries.

Jeanette Cunningham







Ok, I'm still being as clear as mud. This is only for the design
process.

As I'm building a database, and I have a query that I'm looking at
spread across the top of the screen. (The object I'm working on
doesn't really matter) I move the query to the bottom right corner of
the screen. I would like to save the query so that the next time I
open it, it appears in the bottom right corner rather than spread
across the top of the screen.

This really doesn't have anything to do with the user interface that
I'm designing, or interaction with the data. I just want to be able
to arrange the windows the way I like during the development process.

Thanks again,
Chris M.- Hide quoted text -

- Show quoted text -
Click to expand...

Ok, after I've arranged them, is there a way to save that "layout"?

Thanks again to all that have contributed to this simple yet difficult
question.

Chris M.
 
M

mcescher

Chris,
no, as far as I know, there is no way to save the layout.
I am completely used to setting up the layout manually when I open a
database, after a few years of using Access.

Jeanette Cunningham











Ok, after I've arranged them, is there a way to save that "layout"?

Thanks again to all that have contributed to this simple yet difficult
question.

Chris M.- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks to all that tried to lend a hand. It's much appreciated.

Chris M.
 
Top