by Jonathan Halder | Aug 28, 2024 | Blogging, MS Access, MS Access Features
This article from Microsoft Support discusses the differences between using Microsoft Access and Excel for managing data, helping users decide which tool is best suited for their needs. I’ve used Copilot to help me create a quick summary of the article you can...
by Jonathan Halder | Aug 27, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
There are of course a multitude of uses for a relational database system. Remember that although natively Access defaults to storing data relationally in tables using the file based ACE system (Access Connectivity Engine), it can really use any ODBC or OLE DB...
by Jonathan Halder | Aug 26, 2024 | Blogging, MS Access, MS Access VBA Coding
There is a way to run multiple lines of code on one line in VBA and another way to separate one line of VBA code across multiple lines. I find in particular when using the Immediate Window in the VBE editor, that if I want to test a class I’m using there, I need...
by Jonathan Halder | Aug 23, 2024 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
I was posting some information on the Option Compare statement in Access VBA and was trying to find more information about the Option Compare Database default option and what exactly it means. From the online Microsoft VBA documentation: Option Compare Database can...
by Jonathan Halder | Aug 21, 2024 | Blogging, MS Access
I can not overstate the importance of the relationship between an Access developer / development company and the customer. If bad, this relationship will create disillusionment and disappointment on both sides of the aisle and become toxic and destructive. So what are...
by Jonathan Halder | Aug 20, 2024 | Blogging, MS Access
Is Microsoft Access really a low cost option? It certainly can be if you are a DIY person who already owns Microsoft Office and think of low cost as “not spending lots of cash”. There is always a learning curve which takes time to work through, as well as...
