[AccessD] max number of controls

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




More information about the AccessD mailing list