Need to add more fields but schema is expanded to its maximum?

[Anita75]

Hi,

I need support,
1. I have a number of tables that is fed by using schema from Access 2007
2. The schema is added with several fields/posts and is expanded as much as
possible, BUT the schema has has limitation in size (height), suddenly it is
not possible to expand the schema (details area) any more, but I need to add
more fields/posts from tables
3. All input data should be inserted into tables in one step
4. Any solutions?

(Is it possible to expand the schema in any way or is it possible to
syncronize two different schema as one schema, or something like that)

Anita

 

[John W. Vinson]

Hi,

I need support,
1. I have a number of tables that is fed by using schema from Access 2007
2. The schema is added with several fields/posts and is expanded as much as
possible, BUT the schema has has limitation in size (height), suddenly it is
not possible to expand the schema (details area) any more, but I need to add
more fields/posts from tables
3. All input data should be inserted into tables in one step
4. Any solutions?

(Is it possible to expand the schema in any way or is it possible to
syncronize two different schema as one schema, or something like that)

Anita

I'm *guessing* that you're using the term "schema" where most of us would use
"form", right?

If you're running out of space on the screen for entering data I can make two
suggestions:

1. Add a Tab Control to the form. This will let you use the same visible
screen space over and over again, with several controls on the first tab page,
several more on the second, and so on.

2. MUCH more important: if you're running out of room because you are
constantly adding new fields to your table's design... STOP. "Fields are
expensive, records are cheap"; if you have more than thirty fields in your
table, you almost certainly need to normalize your design. The table should be
designed based on the logical relationships of the information in the table,
NOT based on paper forms used to enter data.