About Access Righttm & the Programmer

Software toggle normal/advanced set to advanced

It started as a favor to a friend

It's been a long journey, my growth as an Microsoft Access developer. In 1992, I was working as a mechanical engineer specializing in product design when a friend needed a way to model cleaning work in large institutions. First we tried spreadsheets, then realized the type of data would be managed by a database. Since Microsoft Access was just recently realized and I loved software, I gave it a whirl. It turned into an application we still market today with over 30,000 hours of continous improvements and over 1/4 of a million lines of codes driving it, proving Access is not a toy. This was a hobby and side business until 2012 when I quit the day job to develop full time.
Mechanical Engineering: My childhood hero was Thomas A. Edison and I wanted to be an inventor too. So after an initial failure to get my bachelor's, and a stint in the Army, I returned to school and graduated with a dream of having my own business.

I had a lot of fun, but it became clear that anything in Mechanical Engineering required a lot of cash to start and I have a entreprenurial bent. So my dream changed to having my own software business.
Mechanical engineering taught me much, and, if you're interested, here's my "ME" resume (also shown below).
This is the stuff I actually like to deal with. The VBA function below extracts the folder path from a string (text) containing a path and file name.


Public Function FolderFromPath(strFullPath As String) As String

Dim i As Integer

For i = Len(strFullPath) To 1 Step -1
    If Mid(strFullPath, i, 1) = "\" Then
        FolderFromPath = Left(strFullPath, i)
        Exit For
    End If
Next

End Function
Software Engineering: There were early signs I might have fun developing. I did win a "design" award in college for programming a model of a motorcycle linkage in Basic, back when it came with Windows 3.

But, I never realized then the creative possibilities and assumed it was more like accounting. Boy was I wrong. Good software design combines function with process and ascetics. Here is my "Software" resume (also shown below).
Below: Welcome to my home office ’shop'. This is all an access developer needs to craft fine products. It starts with a PC or two, the home-built workstations (red and black) at the top. Monitors, phones, etc. And, of course a decent coffee maker. Lighted keyboards for those late-night sessions help, as does a quality desktop mic for crystal-clear communications.
100%
​EFFICIENCY
Software essentials include Office, of course, as well as image editing, online backup, secure online servers for file transfer, online conferencing tools, website hosting services, ad campaign services, screen recording video software, communications and internet services. Altogether, including depreciation, monthly costs are less than $500. That low overhead is important since it translates into value. Significantly: what it doesn't include; no office to rent, and no owner or business manager to support.

The "MS Access Programmer" Resume

The Developer's "Mechanical Engineering" Resume