by Jonathan Halder | Apr 30, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
The last few days I’ve been adding lots of VBA code for updating views and tables to put new fields into my SQL Server backend. I’ve been using the MZ-Tools regular expression search and replace tool to do some heavy lifting for quoting paragraphs of SQL...
by Jonathan Halder | Apr 15, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today’s work was to fix logic errors in my application. The problem is that overlapping data in files that normally deletes the older data and replaces it with the newer data is replacing all the older data even though it is earlier than what appears in the...
by Jonathan Halder | Apr 9, 2025 | Blogging, MS Access, MS Access Features, MS Access Queries, MS Access VBA Coding
Today I started working through using a transaction to cover another complex series of database transactions. One of my customers was receiving an error message that a record was already deleted during an import. In this case, the import process takes a while and if...
by Jonathan Halder | Apr 7, 2025 | Blogging, MS Access, MS Access Queries
In SQL Server you can count up the distinct values in a column of a query using syntax like: SELECT SalesPersonID, COUNT(DISTINCT CustomerID) As NumberOfDistinctCustomersServed FROM ClosedSales GROUP BY SalesPersonID This will give you the number of unique customers...
by Jonathan Halder | Apr 2, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding, Versioning
In today’s adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer...
by Jonathan Halder | Mar 27, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Did you know that you can drag and drop items from the navigation pane in one Access database to another Access database? I used this feature today as I needed to copy a somewhat complex form to display a series of entries in a linked table in both databases filtered...
