Max Controls on a Single Form.

Greetings;

I need to create a form with over 400 groups of 5 fields. So a total of
2000 seperate controls.

I was only about to get 500 controls on the form before Access told me it
was not possible to create more on the same form.

Solution : Maybe to create 4 seperate Forms containing 500 controls each,
and open them as I need them.

Any other suggestions?

I think you problem is far more basic. If you need that many controls on a
form, you have not designed your database structure (tables and
relationships) correctly. You need to do some research into the topic of
Normalization and good Database Design methodology.

A very good book is: Database Design for Mere Mortals by Michael Hernandez

Also, check out these sites:

http://www.datamodel.org/NormalizationRules.html
http://support.microsoft.com/default...;en-us;q209534
http://support.microsoft.com/default...b;EN-US;164172
http://support.microsoft.com/default...;en-us;q234208
http://www.databaseanswers.com/data_models/index.htm


--
--Roger Carlson
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L

"Lethoric" wrote in message
...
Greetings;

I need to create a form with over 400 groups of 5 fields. So a total of
2000 seperate controls.

I was only about to get 500 controls on the form before Access told me it
was not possible to create more on the same form.

Solution : Maybe to create 4 seperate Forms containing 500 controls each,
and open them as I need them.

Any other suggestions?

Good morning

Number of controls and sections you can add over the lifetime of the form or
report is 754. It sounds like you have exceeded this amount. You will have
to keep the number of controls below this amount.

I cannot think of an application where that number of controls would be
required on a single form.

To fix what you have, create a new database and import all of the object.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.





Greetings;

I need to create a form with over 400 groups of 5 fields. So a total of
2000 seperate controls.

I was only about to get 500 controls on the form before Access told me it
was not possible to create more on the same form.

Solution : Maybe to create 4 seperate Forms containing 500 controls each,
and open them as I need them.

Any other suggestions?

Thanks;

I'll check them out. Actually been looking for a good read.

Sincerely;
~Alan Colby

"Roger Carlson" wrote:

I think you problem is far more basic. If you need that many controls on a
form, you have not designed your database structure (tables and
relationships) correctly. You need to do some research into the topic of
Normalization and good Database Design methodology.

A very good book is: Database Design for Mere Mortals by Michael Hernandez

Also, check out these sites:

http://www.datamodel.org/NormalizationRules.html
http://support.microsoft.com/default...;en-us;q209534
http://support.microsoft.com/default...b;EN-US;164172
http://support.microsoft.com/default...;en-us;q234208
http://www.databaseanswers.com/data_models/index.htm


--
--Roger Carlson
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L

"Lethoric" wrote in message
...
Greetings;

I need to create a form with over 400 groups of 5 fields. So a total of
2000 seperate controls.

I was only about to get 500 controls on the form before Access told me it
was not possible to create more on the same form.

Solution : Maybe to create 4 seperate Forms containing 500 controls each,
and open them as I need them.

Any other suggestions?

Greetings StCyrM;

The main database contains 500 employees.

The form that I need to make asks for basic information "client name"
"Telephone Number" "Current Workstation" _text box "move to" _ and "New W/S".

Essentially we take a bulk of Employees and swap them between workstations.
Some times we move 5 to 10, but other times we move whole floors. In doing
so, we need to move the Desktop / Telephone at their current location to the
New one, and the Desktop / Telephone from the New workstation back to where
they came from or to another workstation all together.

Gathering this information I move it into a Temporary Database, or Table and
then shuffle it back into the main Database with the new W/S.

Sincerely;
~Alan Colby

"StCyrM" wrote:

Good morning

Number of controls and sections you can add over the lifetime of the form or
report is 754. It sounds like you have exceeded this amount. You will have
to keep the number of controls below this amount.

I cannot think of an application where that number of controls would be
required on a single form.

To fix what you have, create a new database and import all of the object.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.





Greetings;

I need to create a form with over 400 groups of 5 fields. So a total of
2000 seperate controls.

I was only about to get 500 controls on the form before Access told me it
was not possible to create more on the same form.

Solution : Maybe to create 4 seperate Forms containing 500 controls each,
and open them as I need them.

Any other suggestions?

-----Original Message-----
Greetings StCyrM;

The main database contains 500 employees.

The form that I need to make asks for basic
information "client name"
"Telephone Number" "Current Workstation" _text box "move
to" _ and "New W/S".

Essentially we take a bulk of Employees and swap them
between workstations.
Some times we move 5 to 10, but other times we move whole
floors. In doing
so, we need to move the Desktop / Telephone at their
current location to the
New one, and the Desktop / Telephone from the New
workstation back to where
they came from or to another workstation all together.

Gathering this information I move it into a Temporary
Database, or Table and
then shuffle it back into the main Database with the new
W/S.

Alan, what you could do (assuming that each desk and
telephone has some sort of inventory control tag with a
unique number on it; if not your auditors will probably be
very cross with you anyway, so I'd recommend you start
labeling all your equipment) is:

Set up one Employees table with the EmployeeID, name, etc.
Whatever personal data you want to track for each
employee. You also need a LocationID field for the
employee, probably the floor/room#.

Then you would set up an Equipment table that would have
an EquipID field, a Type field (phone or desk, etc.), and
any other data you need to track for each piece of
equipment. In general it's better to add a bunch of fields
that you and your clients think you *may* need at some
point than having to add fields later. It's easier to not
use a field in a tbale rather than have to keep changing
the tbale structure, which can affect your queries and
forms.

Then you need a Location table that has one record for
each workspace in your office. LocationID, floor, room#,
whatever you need here.

You'll need a third table (which in relational database
design is called an "intersection" table, because it
matches records in the two tables you created above and
therefore sits at the intersection of those two tables)
called EquipmentLocation or something similar. In this
table you have the LocationID (must match with the same
field in teh Location table), a Date field to show when
each piece of equipment was installed for this location,
and an EquipmentID field to show which piece of equipment
was moved.

Then when an employee is moved or gets new equipment, you
add a record to the EquipmentLocation table for each piece
of equipment that's assigned to them. You change the
LocationID field for this employee in the Employees table.
If you have to move old equipment out to a vacated
location, you do that in the EquipmentLocation table.

Then you can do queries to "join" these tables together as
needed.

HTH,