by Jonathan Halder | Jan 8, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a weird problem that took me about 2 hours to track down. I had a normal form in Continuous view that was not triggering an error of any kind, but would not write to the record. It could see all the records, you could navigate to them, and I had a delete...
by Jonathan Halder | Jan 7, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
Ok, so in some cases, VBA is nice to you and destroys variable references you use when you utilize the SET keyword. Let’s say you do something like this: Dim dbObj As DAO.Database Set dbObj = CurrentDb This is in the context of some kind of function or sub, or...
by Jonathan Halder | Dec 26, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
One of the features of our Access JumpStart application template is a form resizing class: This VBA class, HAL_FormResizeCls, is designed to handle the resizing of forms and their controls in Microsoft Access. Here’s a summary of its functionality and how...
by Jonathan Halder | Dec 20, 2024 | MS Access, MS Access Forms, MS Access Tables, MS Access VBA Coding, TDD
I’ve been sick for the past two days, and kept getting too tired to create a post for the day. So I did what I could for my clients first, then slept. 😛 I’m feeling much better today, so I’m back in the messaging chair. I ended up scrapping my idea...
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...
