[AccessD] Unbound Form Check For Changes

LOL, that was not a diatribe against unbound controls, it was a diatribe against minimizing the 
design / engineering required to do the job right.

BTW, I was asked to go out to Beaverton OR (from RTP Raleigh-Durham) to work with a team of 
engineers implementing an Access system.  My job was to design the code behind 6 small forms.  This 
is where I discovered the "miles of code" I mentioned, in this system.  In three weeks I designed a 
tiny framework for handling all of the aspects of reading / distributing / checking / writing of 
these unbound forms.  It consisted of about 8 classes total.  I had a class for modeling the ADO 
recordset used to read / write the data.  It had methods for building out CRUD behaviors, and ADO 
objects for establishing the connection and recordsets used.

I had a form class, a class for each of the controls (text / combo / check box / command button) , 
and I had a couple of helper classes.

It was a PITA, but it was not rocket science.  Much of the work is the modeling itself, what are the 
objects and what do they do. How do they interface to each other.  What data needs to be stored 
about each object while we are working with them?  What code is needed to implement their behaviors?

When I was done, each form used the same programming model to perform all of the work required to do 
the job.  A framework is just a well behaved system of classes each doing its part in the overall 
dance production.

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 3/23/2014 10:50 PM, Bill Benson wrote:
> BTW As a diatribe against unbound controls, I like it. I just wish I could
> get away with all my laziassness using bound controls, but they never work
> for me because I never seem to know how to create an updateable recordset
> the way I do things. Like have large flat-ish tables wherein I need to
> create group by queries to present simplified information for them to
> cherry-edit values on unbound forms, then push the changes back to the main
> tables.
>
> No doubts about it John, you are the professional's professional. I am just
> a hack. Not proud of it, and maybe someday someone will pay me to learn
> better techniques. If they don't I will just do what I have time to do.
>
> BB
>


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com