by Jonathan Halder | Dec 6, 2023 | MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
I’ve been discussing how I use version control in 3 previous emails / articles which you can find here: Access Programming – What I do and Why (source control) | Access JumpStart Access Programming – What I do and Why (source control part 2) | Access JumpStart Access...
by Jonathan Halder | Mar 7, 2022 | MS Access Forms, MS Access Queries
This error occurs because, drum-roll please…. The setting for this property is too long. So in this particular case, the developer was trying to create a long SQL string using multiple UNIONs with a complex query and trying to set this string to the RowSource...
by Jonathan Halder | Jun 18, 2021 | MS Access, MS Access Forms, MS Access Queries
I recently experienced a frustrating issue that had me scratching my head for a while. I had a PO form with a Line Item subform and I could edit lines and when I tried to delete a line it was removed from the subform. BUT… If I closed and reopened the same PO...
by Jonathan Halder | Sep 11, 2020 | MS Access Queries
Presented with the problem: You have a stock of inventory of items you are renting. You know how many you have purchased. You have what customers have ordered for particular dates. You want to know while entering an order, how many items are available for a...
by Jonathan Halder | Jun 19, 2020 | MS Access Queries, MS Access Tables
A common database issue in the world is the need to store lists of related items. This might be a Bill of Material (or BOM) for a business application to describe all the parts and assemblies needed to ship a particular product, or it might be something like meal...
by Jonathan Halder | Jun 3, 2020 | MS Access Queries, MS Access Tables
In certain cases I have used temporary tables in order to speed up reports. In these cases, the queries are usually complex and the backend and / or front end are being run in a multiuser environment with multiple users accessing the reports at any given...
