[AccessD] Classes and events

[John Colby]

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