If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
-----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, |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
Passing value to modal child form in MS Access using VBA? | Grahammer | Using Forms | 6 | July 4th, 2004 11:53 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Max. # of Controls on Form | BGates | Using Forms | 2 | June 16th, 2004 04:25 AM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |