[AccessD] Offsite Access Contractor Opportunity

Wed Oct 27 18:17:20 CDT 2021

Seems like a good topic to take offline haha.

On Wed, Oct 27, 2021 at 3: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
>