by Jonathan Halder | Jan 14, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
One strategy I have used to run automated processes with Access is to use Command Line switches. So to start up Access you use the Access program “MsAccess.exe”, usually with the full path to it, then use the database you are opening as an argument, and...
by Jonathan Halder | Dec 31, 2024 | MS Access, MS Access Features, Versioning
How do you choose what to work on next for a customer? If you have a long backlog it can get somewhat dicey. Try to keep balanced between working on longer term tasks and knocking out small requests as you go. This can be tricky depending on how you code and what you...
by Jonathan Halder | Dec 23, 2024 | MS Access, MS Access Features, MS Access VBA Coding
I’ll boil it down to this: SDOpenAI API is like doing chats with CoPilot. It forgets everything between each question and the Access plugin needs to resend the context of your questions each time. It does this in the background, but doesn’t know anything...
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 | Nov 27, 2024 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
In the following linked message, I started creating a form and within the form code module I created some local variables to store a class object for accounts and then used the Form Current event to test the form to make sure it was valid before running the Account...
