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...
by Jonathan Halder | Mar 24, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access VBA Coding
Today, for my customer’s app, I wrote some VBA code in an after update routine of a textbox to strip out non-numeric characters and reformat them into a phone number format the customer wanted. Private Sub employee_phone_number_AfterUpdate() If...