Case Studies

Error In Loading DLL And DAO DLL Download

The other day I was doing a database modification for a long time customer, and I was compiling their database, when the compilation failed at a line of VBA code calling for a DAO object. FYI: I originally designed this bit of code for a prior Access version and now they had upgraded to an […]

Continue Reading

Converting A Excel Spreadsheet To Access Database

While I was scouring the Upwork gigs, one caught my eye, they left an Excel spreadsheet example and so I decide it was good enough to try and recreate it in Access database format. I just couldn’t pass up the challenge on this one. So I figured I wanted to share the journey with you […]

Continue Reading

MS Access Stock Control Database Pt1

I am in the process of converting an Excel spreadsheet into an MS Access database. One of the first questions I asked was, “Are you doing this manually” and “How”. The reason is simple, I don’t want to try and figure out a new way of processing for them. If they are already used to […]

Continue Reading