[AccessD] Classes and events

[John Colby]

I love python but I am not enamored with the gui generating side of things.
Access has a beautifully structured control set for building forms and
raising / hooking events.

On Fri, Aug 28, 2020, 15:31 Arthur Fuller <fuller.artful at gmail.com> wrote:

> Simple tools such as MA-Tools could analyse your code and at least count
> the lines, which is not to say that line-count is a measure of quality. You
> don'r need to worry about that, though. You have already proved your
> mettle.
> As to continuing Access development, I only work in this environment for
> quick sketches, then move either to C# or Python, mostly the latter.
>
> On Fri, Aug 28, 2020 at 2:36 PM John Colby <jwcolby at gmail.com> wrote:
>
> > For me, the largest app I ever wrote in Access was a call center app for
> a
> > disability insurance processing company.  It was about 180 tables by the
> > time I left.  At least one form for each table.  Sometimes two if I
> needed
> > a standalone data entry form and a subform for a given table.  Plus
> > reports.
> >
> > The framework I discussed in a new post was instantiated once for the
> app,
> > and then each form would load a wrapper class for itself, whenever it
> > loaded with the control scanner, which would wrap every control in it's
> own
> > class.  Automatic setup as a form loads, and teardown as a form closes.
> >
> > My framework was where most of the code lived for the app.    Only the
> > case of "one off" functionality specific to the business rules of the app
> > would live inside of modules or classes in the app itself.  The framework
> > was a library.  I had an agreement that the framework belonged to me,
> with
> > a "right to use" for the client.  Fitting an entire app with my framework
> > is almost trivial.  Each form has to be opened and the form wrapper class
> > loaded in OnOpen and torn down in OnClose.  There were a couple of tables
> > to drive the framework.
> >
> > TBH I have no idea how many lines of code.  Far fewer than if I had
> > duplicated all that code in each form.
> >
> > On Fri, Aug 28, 2020 at 10:42 AM Daniel Waters <df.waters at outlook.com>
> > wrote:
> >
> > > Hi Mark,
> > >
> > > I’ve done the same myself.  I’m curious what we each consider to be ‘a
> > > large Access application’ how many lines of code are in it?  The four
> > I’ve
> > > written were all between 50K and 80K LOC.
> > >
> > > MZ Tools has a quick LOC counting feature.
> > >
> > > Thanks!
> > > Dan
> > >
> > > Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for
> > > Windows 10
> > >
> > > From: Mark Simms via AccessD<mailto:accessd at databaseadvisors.com>
> > > Sent: Friday, August 28, 2020 7:53 AM
> > > To: accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>
> > > Cc: Mark Simms<mailto:mar.ko at verizon.net>
> > > Subject: Re: [AccessD] Classes and events
> > >
> > > I am supporting a large Access application that I wrote over 5 years
> ago.
> > > My client tried to get quotes for replacing it, but they were over 1/2
> > > million dollars....so the app still stands.
> > >
> > > Mark Simms
> > > marksimms at verizon.net
> > >
> > > -----Original Message-----
> > > From: Bill Benson <bensonforums at gmail.com>
> > > To: Access Developers discussion and problem solving <
> > > accessd at databaseadvisors.com>
> > > Sent: Fri, Aug 28, 2020 1:42 am
> > > Subject: Re: [AccessD] Classes and events
> > >
> > > But just a note asking a question about “out there” to people “in here”
> > may
> > > not be the asking the right place.
> > >
> > > On Fri, Aug 28, 2020 at 1:40 AM Bill Benson <bensonforums at gmail.com>
> > > wrote:
> > >
> > > > Nope :(
> > > >
> > > > On Thu, Aug 27, 2020 at 12:02 PM John Colby <jwcolby at gmail.com>
> wrote:
> > > >
> > > >> I also uploaded a bunch of Access databases with examples of
> > classes.  I
> > > >>
> > > >> haven't opened access in a few years. Is anyone out there still
> > actively
> > > >>
> > > >> developing i Access?
> > > >>
> > > >>
> > > >>
> > > >>
> > > >>
> > > >> --
> > > >>
> > > >> John W. Colby
> > > >>
> > > >> Colby Consulting
> > > >>
> > > >> --
> > > >>
> > > >> 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
> > > --
> > > 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
> > >
> >
> >
> > --
> > John W. Colby
> > Colby Consulting
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>