471,108 Members | 1,571 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

A2K - 754 number of control limit reached on form

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
Oct 30 '08 #1
8 3596
On Oct 30, 4:20*pm, "Deano" <de...@mailinator.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.

Oct 30 '08 #2
On Oct 30, 6:45*pm, lyle fairfield <lyle.fairfi...@gmail.comSHOULDA
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.

Oct 30 '08 #3
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" <de***@mailinator.comwrote in message
news:49***********************@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


Oct 31 '08 #4
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
pl*****************@msn.com
Nov 2 '08 #5

"Albert D. Kallal" <Pl*******************@msn.comwrote in message
news:7V*******************@newsfe01.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...
Nov 6 '08 #6
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" <Pl*******************@msn.comwrote in message
news:7V*******************@newsfe01.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...

Nov 12 '08 #7
"Robert S." <ro*******@googlemail.comwrote in message
news:49**************@googlemail.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.
Nov 19 '08 #8
"Deano" <de***@mailinator.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


Nov 21 '08 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Galli | last post: by
4 posts views Thread by Tristan | last post: by
10 posts views Thread by Yuk Tang | last post: by
1 post views Thread by milkyman | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.