[AccessD] Dirty Cancel Clear all controls

Stuart McLachlan stuart at lexacorp.com.pg
Wed Feb 14 18:38:07 CST 2018


For those not familiar with it,  I've posted a copy of Decorrupter at

http://www.camcopng.com/decorrupter

-- 
Stuart

On 14 Feb 2018 at 14:56, Rocky Smolin wrote:

> I've used the Decorrupter posted here a few months ago several times
> and it's saved my bacon every time.  It exports all the objects and
> reimports them and everything comes out looking just dandy.
> 
> R
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Arthur Fuller Sent: Wednesday, February 14, 2018 1:32 PM To: Access
> Developers discussion and problem solving Subject: Re: [AccessD] Dirty
> Cancel Clear all controls
> 
> This bug has been lurking in Access VBA for years, and other than the
> fact that I know what to do when it bites me, I have no information or
> insight regarding its cause or this bug, or the apparent
> inability/unwillingness of the Access team to repair it.
> 
> What I have discovered, through trial and error rather than insight,
> is that a second solution exists: export the code to a text file and
> then re-import it, which is functionally the same, of course. I've
> done this and noted that the "junk code" is magically eliminated
> during the export.
> 
> Sidebar question:
> 
> I've never inspected the exported text from a form to see if the
> re-imported text can totally recreate the form of interest. Do you
> know? My thought is that somewhere all this data is stored as text,
> but perhaps limits its export. I don't really know, but if it is, then
> reverse-engineering some samples ought to provide enough information
> to design a text-template system that auto-generates a bunch of forms
> (perhaps containing subforms, in which case recurse).
> 
> I've written a lot of code similar to the spec described above, in
> languages other than Access, but never tried it in Access. Do you have
> any experience in this sort of experiment?
> 
> Arthur
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list