by Jonathan Halder | Apr 10, 2025 | Blogging, MS Access, MS Access Features
Day 1 Agenda: 1Access Community UpdateKarl Donaubauer2Programming Modern ChartsColin Riddington3Microsoft Graph APIMaria Barnes4VBE_ExtrasJohn Mallinson5News from the Access TeamMicrosoft Session 1 was a little scary, Frankly, Microsoft does not seem to want Access to...
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 8, 2025 | Blogging, MS Access, MS Access VBA Coding
Today’s Access adventure involved refactoring code as an evolution from getting a particular set of line item records associated with a file to be processed when that file was selected from another form. In the first iteration of the code for testing, I was...
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 4, 2025 | Blogging, MS Access, MS Access VBA Coding
First of all I am notoriously bad at knowing when to quit. I keep trying things thinking I’m almost there and that I’ll get that code working in the next 5 minutes. Then 3 hours later I have a huge mess and it’s not done yet with me scratching my...
by Jonathan Halder | Apr 3, 2025 | Blogging, MS Access, MS Access VBA Coding
Today’s adventure in Access was a problem my customer was having with an imported file. Their shipment requests were being supplied via electronic delivery and then they send a confirmation via the same electronic delivery system. The recipient of the shipments...
