by Jonathan Halder | Dec 12, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
I am going to test out the free version of the SDOpenAI Access plugin to see how well it works to pair program with. The web site is in German, but I had no problem downloading the executable file (albeit with multiple warning prompts from Edge about being a file that...
by Jonathan Halder | Oct 18, 2024 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
If you’ve ever wondered whether a SQL statement you executed actually modified any records, there is a property of the DAO database object that can help you. You can get the number of affected records of a DELETE, UPDATE, or INSERT type query immediately after...
by Jonathan Halder | Oct 14, 2024 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
Despite my best efforts, sometimes I end up with complicated code. The logic snakes and wraps around like crazy river rapids. Today, I had such a part of my customer’s database that I was working in and it was not easy. Most of the time this problem occurs...
by Jonathan Halder | Oct 7, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables
This morning I was working on a query for a customer report that took me longer than I expected and produced more problems than I expected. I actually had 3 tables named customers, orders, and payments. Customers can have multiple orders, and have a one to many...
by Jonathan Halder | Oct 4, 2024 | Blogging, MS Access, MS Access Queries, MS Access Tables, MS Access VBA Coding
The Access 97 database I was trying to get working on my 365 Access was written to scramble data in existing tables in a destructive way so that users of a forum or other developers could look at code without seeing sensitive data. I copied some large tables I had...
by Jonathan Halder | Sep 23, 2024 | MS Access, MS Access Queries, MS Access VBA Coding
I’m working in Access today and I noticed that a confirmation dialog box I have set up to ask me as a developer if I really want to send an email was not working. Initially I thought it was because of a flag that was failing to get set, but that wasn’t it....
