[AccessD] Form corruption?

John W. Colby jwcolby at gmail.com
Tue Mar 3 16:42:47 CST 2015


Can you trap and ignore the error?  If it is saying that it can't delete 
an object because the object doesn't exist then just ignore the error?

John W. Colby

On 3/3/2015 3:46 PM, Janet Erbach wrote:
> 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
>
>



More information about the AccessD mailing list