A2K - 754 number of control limit reached on form

[Deano]

How can I reset this count? My form is stable now and doesn't have many
controls on it, though obviously it's seen alot of deletions as the form has
evolved and this contributes to reaching the 754 limit.

I have tried exporting to another database and then importing it back with
no luck.

I'm testing an add-on that applies a spiffy effect to command buttons and it
reports the 754 error on this particular form.


thanks

[lyle fairfield]

Re: A2K - 754 number of control limit reached on form

On Oct 30, 4:20 pm, "Deano" <de...@mailinat or.comwrote:

How can I reset this count?  My form is stable now and doesn't have many
controls on it, though obviously it's seen alot of deletions as the form has
evolved and this contributes to reaching the 754 limit.
>
I have tried exporting to another database and then importing it back with
no luck.
>
I'm testing an add-on that applies a spiffy effect to command buttons andit
reports  the 754 error on this particular form.
>
thanks

Have you tried?

SaveAsText acForm, "Name of Form", "Temp.Txt"
SaveFromText acForm, "New Name for Form", "Temp.Txt"

and checked out the number of controls on the new form.

Really smart guys and gals would experiment with this on a copy of the
form or a copy of the database.

[lyle fairfield]

Re: A2K - 754 number of control limit reached on form

On Oct 30, 6:45 pm, lyle fairfield <lyle.fairfi... @gmail.comSHOUL DA
wrote:

Have you tried?

SaveAsText acForm, "Name of Form", "Temp.Txt"
LoadFromText acForm, "New Name for Form", "Temp.Txt"

and checked out the number of controls on the new form.

Really smart guys and gals would experiment with this on a copy of
the
form or a copy of the database.

[tina]

Re: A2K - 754 number of control limit reached on form

have you been compacting your db as you work on it? if not, you should do it
frequently during development - whether or not it fixes your current form
issue. also, have you tried creating a new blank form, then opening the
problem form in Design view, pressing Ctrl+A to select all objects, then
Ctrl+C to copy them. then open the new form in Design view and press Ctrl+V
to paste. if you have code in the problem form's module, you'll need to
highlight and copy it, then paste into the new form's module. delete the old
form, then compact the db, then rename the new form and compact again.

and before you do any of the above, make sure the Name Autocorrect option is
turned OFF. in the database window, from the menu bar select Tools | Options
| General tab.

hth


"Deano" <deano@mailinat or.comwrote in message
news:490a174c$0 $10551$db0fefd9 @news.zen.co.uk ...

How can I reset this count? My form is stable now and doesn't have many
controls on it, though obviously it's seen alot of deletions as the form

has

evolved and this contributes to reaching the 754 limit.
>
I have tried exporting to another database and then importing it back with
no luck.
>
I'm testing an add-on that applies a spiffy effect to command buttons and

it

reports the 754 error on this particular form.
>
>
thanks
>
>

[Albert D. Kallal]

Re: A2K - 754 number of control limit reached on form

1 ) open form in design mode, and then go file->save-as, and give the form a
new name.

2 ) delete original form, and rename the form from above to the original
form name...

The above will re-set the object count for the form...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKa llal@msn.com

[Deano]

Re: A2K - 754 number of control limit reached on form


"Albert D. Kallal" <PleaseNOOOsPAM mkallal@msn.com wrote in message
news:7V8Pk.2988 4$nl3.12855@new sfe01.iad...

1 ) open form in design mode, and then go file->save-as, and give the form

a

new name.
>
2 ) delete original form, and rename the form from above to the original
form name...
>
The above will re-set the object count for the form...

Just got round to revisiting this form and bizarrely, nothing I do fixes
this. Tried your solution, then Tina's but I keep getting the error. I'm
going to cry...

[Robert S.]

Re: A2K - 754 number of control limit reached on form

Probably a control that runs wild. Did you try to selectively start
deleting elements from this one form (of course you should make a backup
before ;-) ).?

Found several weird issues with all sorts of Acc that cannot be
explained (other than from inside MS-Access developers debugger). The
error messages sometimes lead you totally wrong.

I believe in your case any strange side effect will produce this.

rob*

Deano wrote:

"Albert D. Kallal" <PleaseNOOOsPAM mkallal@msn.com wrote in message
news:7V8Pk.2988 4$nl3.12855@new sfe01.iad...

>1 ) open form in design mode, and then go file->save-as, and give the form

a

>new name.
>>
>2 ) delete original form, and rename the form from above to the original
>form name...
>>
>The above will re-set the object count for the form...

>
Just got round to revisiting this form and bizarrely, nothing I do fixes
this. Tried your solution, then Tina's but I keep getting the error. I'm
going to cry...
>
>

[Deano]

Re: A2K - 754 number of control limit reached on form

"Robert S." <robsmiler@goog lemail.comwrote in message
news:491A8C16.8 070201@googlema il.com...

Probably a control that runs wild. Did you try to selectively start
deleting elements from this one form (of course you should make a backup
before ;-) ).?
>
Found several weird issues with all sorts of Acc that cannot be
explained (other than from inside MS-Access developers debugger). The
error messages sometimes lead you totally wrong.
>
I believe in your case any strange side effect will produce this.
>

Thanks I'll give that a go when I'm next able but I'm thinking about
rebuilding the form from scratch. It has an ActiveX control that I want to
remove and replace with new code.

[Larry Linson]

Re: A2K - 754 number of control limit reached on form

"Deano" <deano@mailinat or.comwrote

Just got round to revisiting this form and
bizarrely, nothing I do fixes this. Tried
your solution, then Tina's but I keep getting
the error. I'm going to cry...

Did you try Lyle's suggestion? It has worked for me.

Larry Linson
Microsof Office Access MVP