by Jonathan Halder | May 21, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
So far, I have the SDOpenAI Access Plugin reinstalled and purchased and entered in the license number. Good deal. I was able to create a function header with a descriptive line of Public Function GetDateXDaysPriorToToday(days As Single) As Date with a single for days...
by Jonathan Halder | May 1, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
If you have an interface class object and you implement several types of the object, what can you do when your object has no handler? That’s where the Null Object pattern comes into play. Here’s an example of how you could implement the Null Object Design...
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 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...
