by Jonathan Halder | Dec 17, 2024 | Blogging, MS Access, MS Access VBA Coding, TDD
Today I was struggling with trying to come up with tests for a new feature for an existing Access database. The feature is changing the way addresses are entered for work jobs. Basically the job structure which has had embedded address fields like street, city, state,...
by Jonathan Halder | Dec 16, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
Karl Donaubauer hosted the Access development team at his German Access Developers Conference and there are some cool things coming down the pipe for us. One of them is re-integrating source code control back into Access: https://youtu.be/dP-YljKct5M?t=943 At one time...
by Jonathan Halder | Dec 13, 2024 | Blogging, MS Access, MS Access VBA Coding
In my message yesterday, I installed the SDOpenAI plugin: Pair programming with AI – SDOpenAI – installing the plugin Today I setup an OpenAI API account (I had already done this in the past so I was beyond the free trial). I purchased $10 worth of resource. The...
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 | Dec 12, 2024 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding
A common Access problem when rolling out Access applications to users is differences in screen sizes and monitor resolutions. I have one client in particular that generally uses 1920 x 1080 resolution for most of their users, but the boss uses multiple monitors at an...
by Jonathan Halder | Dec 10, 2024 | Blogging, MS Access
There are a few strategies you can use to extend the life of Access and make the app available outside of a LAN. Utilizing Remote Desktop of some kind: One way is to use Remote Desktop services. I often just use a VPN to get into a particular LAN where Microsoft...
