KSEABOLT at parkcenter.org
KSEABOLT at parkcenter.org
Mon Oct 27 06:26:07 CST 2003
Did you try placing some of the controls on subforms? We had similar issues with a behavioral healthcare assessment tool that must follow a standard data entry flow. It had well in excess of the limit and we found that placing controls on subforms circumvented the issue nicely. "Pedro Janssen" <pedro at plex.nl> Sent by: accessd-bounces at databaseadvisors.com 10/26/2003 06:10 PM Please respond to Access Developers discussion and problem solving To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> cc: Subject: Re: [AccessD] max number of controls A form where you can select 10 different options. Each option has 30 controls, which i all need for filling fields in word with mailmerge. Add a few other controls to it and you have four hundred controls. Pedro Janssen ----- Original Message ----- From: "William Hindman" <wdhindman at bellsouth.net> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Sunday, October 26, 2003 9:53 PM Subject: Re: [AccessD] max number of controls > ...four HUNDRED controls!!!!!! > ...jumpin' jehozephat!!! ...what in the world could possibly require 400 > controls? > > William Hindman > <http://www.freestateproject.org> - Do you want liberty in your lifetime? > > > ----- Original Message ----- > From: "Pedro Janssen" <pedro at plex.nl> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Sunday, October 26, 2003 3:08 PM > Subject: Re: [AccessD] max number of controls > > > > I did indeed run out of screen, long before i did run out of controls. > > But i fixed that problem by making everything on the form a little bit > > smaller. > > But now i was running out of controls. I shall recreate the form and see > if > > i can add then new controls. This form indeed has had some changes in the > > past years, and there are about 400 hundred controls on the form, > > but i can't imagine that i deleted a few hundred controls in the past. > > > > > > Thanks for all the response > > > > Pedro Janssen > > Cytologist > > > > > > ----- Original Message ----- > > From: "John Colby" <jcolby at colbyconsulting.com> > > To: "Access Developers discussion and problem solving" > > <accessd at databaseadvisors.com> > > Sent: Sunday, October 26, 2003 3:56 PM > > Subject: RE: [AccessD] max number of controls > > > > > > > Are you making them "pages" of the form? Can you replace the pages with > a > > > tab and place controls on the tabs instead? It seems like you'd run out > > of > > > screen long before you ran out of control "slots". > > > > > > John W. Colby > > > www.colbyconsulting.com > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro Janssen > > > Sent: Sunday, October 26, 2003 6:03 AM > > > To: AccessD at databaseadvisors.com > > > Subject: [AccessD] max number of controls > > > > > > > > > Hello Group, > > > > > > is there a maximum number of controls that i can use on a form ( i get > an > > > error, maximum number of controls reached). Is there a way to go round > > this, > > > or can i better not use that many controls on one form and why? > > > > > > Pedro Janssen > > > Cytologist > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com