by Jonathan Halder | Mar 7, 2022 | MS Access Queries, MS Access Forms
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 Forms, MS Access, 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 given...
by Jonathan Halder | Jun 19, 2020 | MS Access Tables, MS Access Queries
[vc_row][vc_column width=”1/1″][vc_column_text]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...
by Jonathan Halder | Jun 3, 2020 | MS Access Tables, MS Access Queries
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 time. The...
Recent Comments