Graham-
Yup, that would work, too. But SaveAsText/LoadFromText are undocumented and
unsupported "features" that only those of us in the know use.
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 Graham Mandeno
Sent: Saturday, May 12, 2012 12:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: Too many checkboxes?
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