can't add, rename, or delete the control

[TimD]

I am using CreateControl to create controls on a form. It had been working
well until recently.

Now I am getting error 29054 which say my database can't add, rename, or
delete the control(s).

Help.

 

[Dale Fye]

Tim,

There is a limit to the number of controls that can be added to a form over
the life of the form (this includes all deleted controls). I think the limit
is something like 750, so if you are dynamically changing the form, you may
be bumping into this limit. I'm not sure how to check for this limit.

My guess is that you might be able to overcome this problem by creating a
template form. Then copy that form to a new form name before you start
dynamically building controls on the form.

Dale

 

[Marshall Barton]

I am using CreateControl to create controls on a form. It had been working
well until recently.

Now I am getting error 29054 which say my database can't add, rename, or
delete the control(s).

Well that's is another reason why you should never modify
form/report objects at run time. The Create... methods are
only intended for use in ***design time*** wizard like
operations.

There are other, even more catestrophic, reasons against
that approach. Do yourself a big favor and rethink this
entire siuation. (The usual approach is to pre-populate the
form with all needed controls and make them
visible/invisible as needed.)