[AccessD] Offsite Access Contractor Opportunity

Wed Oct 27 14:39:53 CDT 2021

Hello Arthur,

I will forward your interest to my friend and the clients with a copy
all email from my other email address of gkjos at comcast.net .  Rocky
and John Colby have already asked to be put in contact with them.
I will be leaving it to the clients to work out who, if any of you
will be awarded the contract.  The clients reside in Europe and so
it's night time there.

To anyone else interested, please reply off the list directly to me at
garykjos at gmail.com  I'm glad we have had this much interest already
and thrilled I won't be begged to take this on myself.  <Grin>

GK

On Wed, Oct 27, 2021 at 2:30 PM Arthur Fuller <fuller.artful at gmail.com> wrote:
>
> Hi Gary.
> I am interested in this opportunity. I have done s bunch of working using
> Oracle and Access to talk to an eHealth database. Lots of the data-access
> stuff was relatively easy, especially since I pretty much wrote the book on
> PITA (Point-in-Time-Architecture, at  least insofar as RedGate has it. (I
> was ahead of Microsoft by at least two years; but then they built PITA in,
> and my solution survives only in SQL databases that do not natively support
> my concept of PITA.
> Here is the thumbnail. Assume a medical discipline (but could just as
> easily be any that deems experimental history as important, including the
> history of a vineyard, or Asperger's
> Consider a person from her health-care perspective. Over the years, she has
> had several physicians, each of whom has prescribe both a therapy regimen
> and an assortment of prescriptions/
> What I wans to know RFN (right forking now) are these facts:
> a) who was or were her physicians at the time?
> b) a list of appointments with each;
> c) a list of drugs precribed on any and all visits within the specified
> time drame
> d) a list of the physician-billings for said patient and time-frame.
> e) I might want to generalise this to include all patients within said time
> frame -- just to ensure the physician is honest and there is no pattern
> within her billing pattern.
>
> so, for starters. let us map bookings v. attendances, and investigate why
> some percentage of patients don't show up. Map the Arrival Time v. the shot
> that you might give this patient that you actually think that humanity is
> Rational. I wish you were right! But every shred of evidence tells me that
> people are wrong way more often than notand I shall NEVER forgive them. A
> Line has been drawn, and I s -- and this measure has nothing to do
> with discipline. The classes of interviewees ranged from MIT grads in
> Statistics to prison inmates at the local prison.
> The book in question here is "*The Undoing Project*", by Michael Lewis, and
> concerns a pair of best friends, one of whose discipline was Psychology and
> the other Economics. Totally opposed, in terms of personality, they formed
> a lifelong bond of BFF-ship.that survived until Amos died. unexpectedly --
> well, unexpected to everyone but Amos -- he knew, and chose to tell no one,
> not his wife, not his best friend Danny. In his mind, this fact was
> unimportant. I tend to adopt the same attitude.
>
> My impending death (I'm almost 74 and have treated my body badly) demands
> that, aside from completing the Revs to the app I am working on, is to plan
> my Exit-Phase, and ensure that the Client of Interest has enough data,
> analysis, etc. to be able to pass this app on to my successor.
> I don't think that it's going to work, grabbing a young and eager CS
> graduate from Ryerosn of U of Toronto or York. I have tried to document
> this app to the best of my ability, but the fact is that in addition to
> knowledge of the code, my successor must also acquire knowledge of the
> Provincial Regulations regarding this discipline, and that task alone might
> take a year. First, given one Canadian province, a given set of Word and
> Excel templates become of interest. So far we have coded three Provinces,
> and it is working well. Some of the ultimate output is in English, some in
> French, and besides the Language Factor, each Canadian province has its own
> specified document formats. So far the code handles only three Canadian
> provinces, but now that I have mapped the Template Hierarchy, adding a new
> province and language has become, well, not quite trivial -- I still have
> to create said templates for each province.
> But I am an ambitious type of guy. I'm gazing South of the 49th Parralel,
> and also East to Europe, and also to the Middle and even Far East. Safety
> Assessment  Engineering is a discipline that exists across all our nations.
> I want to reach out to developers in various nations, and to consider
> possible arrangements with you.
> I have worked out both the language-constraints and the local
> (nation/region/city) constraints that will tell the App what to do given
> the CustomerLocation  which language to use, which set of templates to use.
> The app-design has this in hand.
> Did I miss anything? Can you see holes in my strategy that I missed?
>
> Not even slighty relevent to the topic of interest, but I just wanted to
> say to you all on this list, that I am grateful to be back, and hanging
> about with brilliant minds. And F^^K this retiremement BS, I am BACK, you
> Mofos, I'm not going to die just yet. I got code flowing in my arteries!
> Thanks to all you MoFos! I ain't done yet!
>
> On Wed, Oct 27, 2021 at 10:56 AM Gary Kjos <garykjos at gmail.com> wrote:
>
> > Hello Access Developer friends.
> >
> > A longtime friend of mine is looking for someone to do some work on an
> > Access application that is used by the company that he contracts with.
> > He does work with their Oracle Applications Suite but doesn't know
> > Access at all.  He initially asked me if I would take this project on
> > and I declined as I'm committed to retirement <grin> but mentioned I
> > may have contacts through AccessD that may be interested.
> >
> > I'm forwarding his email describing the situation.  It included a
> > screen shot that won't make it through to the list emails.  If you are
> > interested, contact me and I can direct email you his email including
> > that error screen.
> >
> > If you are interested in this project, let me know and I will forward
> > you his contact information.  The company is a multi division company
> > spread throughout the US and Europe.  They are a manufacturer of
> > exercise equipment among other products.  The specific division using
> > this system is located in Denmark I believe.  It is expected that
> > whomever would do this would be working remotely.
> >
> > Here is his email.....
> > ---------------------------------------
> >
> > Sorry for the delay.   I have spoken with Lina about you and your
> > network of people with Experience in MS Access.   I know you wanted a
> > little bit of understanding of our needs so I thought I would use
> > email to get the questions and conversation flowing.
> >
> > What I do know.
> >
> > We use Access to create files to import into the respective systems.
> > We have MS Dynamics, Exact (Another POS type system) and Oracle.
> > Requests come in through SharePoint and from there they are picked up
> > by Access after some filtering.   From Access, depending on item types
> > and needs, a file is generated for creation of item and or Bill Of
> > Material.   There are tables within Access that do validations.  There
> > are UI’s being used within Access for the different file type needed.
> >
> > From my viewpoint these are the issues we are having….
> >
> > Duplicate records being created in one of the files being generated.
> > Updating records in Sharepoint from the UI button assigned to do this
> > task is not working properly.
> > There is a Refresh button being used to bring data in for validation
> > purposes which we don’t seem to have access to.   We use this but we
> > receive the message…
> >
> > <Screen Shot here displaying a Macro Single Step with an error #3146>
> >
> > General Support
> > -----------------------------------------------------
> >
> > Let me know if you have interest in taking on this project and I will
> > put you in direct contact with my friend and the company people you
> > would be working with.
> >
> > Gary Kjos - garykjos at gmail.com
> > Longtime AccessD member but now retired
> > --
> > Gary Kjos
> > garykjos at gmail.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Gary Kjos
garykjos at gmail.com