by Jonathan Halder | Sep 5, 2024 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access Tables, MS Access VBA Coding
So first things first. It is not recommended that you use spaces or special characters in your table names as it can cause problems referencing them or cases that are ambiguous and may cause unintended results in the code. But maybe you have used them in the...
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 6, 2024 | MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
Access Error (3155) ODBC: “Query timeout expired”. It happened when trying to insert a new record into a linked table called “order” I’m using ODBC driver 17 in this case and it happened twice. Not sure if the user tried to do it twice or...
by Jonathan Halder | Jul 11, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access VBA Coding
I’m revisiting my ListBox control work from these two articles: Access ListBox Row Source and Type | Access JumpStart ListBox Column size adjustments | Access JumpStart The second article discsusses how to adjust column sizes using the ColumnWidths property and...
by Jonathan Halder | Jul 8, 2024 | MS Access, MS Access Features, MS Access Queries
Sometimes my customers ask me for data from their database that they want to see in a way they’ve never looked at or needed to look at it before. When this happens to me and the answer is a data pull, I will often either pull up an existing query with the answer...
by Jonathan Halder | May 31, 2024 | MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding, Versioning
I have created a deployment script which is meant to prepare an Access JumpStart application for a specific live production environment. Access JumpStart is the framework Steve Halder and myself use in creating Access Applications for our customers. I have already...
