[AccessD] Form Lifetime Control Limit -- Final Recommendation

Is anyone aware of some Addin or developer tool which takes care of all
those referencing issues when renaming controls? It would sure be a plus to
have something like that.

Maybe no way to fool proof it.

I agree about starting from scratch.
On Dec 16, 2011 11:16 AM, "Kenneth Ismert" <kismert at gmail.com> wrote:

> >
> > William Benson:
> > Control name property is read only in runtime right? So for ac97 this a
> > manual find and rename operation?
> >
>
> You're correct, name is a design-time property.
>
> You can fairly easily write code to rename controls with the form in design
> view. For the purposes of Lifetime Control Limits, the names don't even
> have to be meaningful, just different from the defaults.
>
> But this code would have to:
>  * Rename control references and event handlers in the form's module
>  * Find and fix all control references in form and control property
> expressions, as well as in underlying queries.
>  * Find and fix control references in queries, forms, reports, macros and
> modules outside of the form in question.
>
> So, if you have to maintain a monster form that was created in A97, and are
> running into control limit issues, the task of fixing it could be huge.
>
> If that is the case, maybe its time to start from scratch with a simpler
> solution that spreads functionality among a number of smaller forms.
>
> -Ken
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>