[AccessD] Classes and events

[Arthur Fuller]

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