[AccessD] Form corruption?

[Janet Erbach]

Hello All -

My Productivity App from WIFI hell has another component to it that I need
to ask about.  This portion of the app was written by my co-worker using a
methodology I did NOT want to employ.  He designed the main form so that
90% of the form objects are *drawn on the form at load time.* Existing
objects are deleted first, and then new ones created using 'CreateControl'.


This is a 2 page form - page 1 with command buttons and page 2 with what
are basically 'hand drawn' charts.  I've attached 2 screen shots to give an
idea of the number of objects that are being created.

He designed it this way so that there would be, in his mind, the ultimate
amount of flexibility in terms of drawing a form with 1 group of machines
or 10 groups of machines.  No objects to hide/activate - just create them
all from scratch each time.

It works pretty well out on the production floor for the most part.  But
when I'm working in the app, making changes to the code behind the form (or
even just making changes to stand-alone modules) it will be very subject to:

Error 29054:  Access can't add, rename, or delete the control(s) you
requested.

It's as if form corruption creeps in behind my back.  I can run the form
repeatedly during development with no issues.  And then out of the blue the
error crops up.  Sometimes re-deleting all of the controls is enough to
correct it;  other times I have to pull a 'clean' form from back up in
order to get un-stuck.

Does anyone know what's behind this error?  Is there are way to keep his
'draw on load' code intact and keep this error from recurring?  Or do I
need to re-create the form with hard-coded objects the way I wanted to in
the first place?

Thank you.

Janet Erbach