Hi John
I've never hit this limit so I haven't needed to find a workaround, but I
would think that SaveAsText/LoadFromText would work. AFAIK there is nothing
in the saved text file that "remembers" the number of deleted controls.
Cheers,
Graham
> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
> Sent: Saturday, 12 May 2012 17:29
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Re: Too many checkboxes?
>
>
> Nope. The limit is something like 754. If you're actually below that
number,
> the solution is to create a new form and copy and paste the controls and
all the
> code from the old one.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> ---------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> Sent: Friday, May 11, 2012 11:27 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Too many checkboxes?
>
>
> I believe a compact will "reset" the internal control count to the number
of
> non-deleted controls.
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Marshall "
<lancucki@...>
> wrote:
> >
> > There is a limit on how many times you can change a form during its'
> > lifetime?
> >
> >
> >
> > It must be Friday.
> >
> >
> >
> > John. Visio MVP
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
> > Sent: Friday, May 11, 2012 4:32 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Too many checkboxes?
> >
> >
> >
> >
> >
> > Hi Dan,
> >
> > You will not be the first to have a Form with
> > lots of check boxes.
> >
> > One user had a Form with so many CheckBoxes that
> > the Access Specification limit on Forms,
> >
> > "Number of controls and sections you can add
> > over the lifetime of the form or report is 754"
> >
> > was hit due to deleting and adding CheckBoxes so
> > many times. You are not likely to hit that limit <g>.
> >
> > If the speed of data entry is an important factor
> > then go ahead.
> >
> > Regards, Clive.
Tidak ada komentar:
Posting Komentar