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 | Jan 6, 2025 | Blogging, MS Access, MS Access VBA Coding
It’s important to have a process to deploy an application to a client or customer. If you don’t have a process in place, Whatever method you use is not reproducible every time. I prefer to automate my deployment process as much as possible. I’d...
by Jonathan Halder | Jan 3, 2025 | Blogging, MS Access, MS Access VBA Coding
Today, I was debugging a problem where a group number was being changed on a row on a continuous form. The group number was being looked up by a query and I found the spot where I thought that was happening. By setting a breakpoint there, I was then able to examine...
by Jonathan Halder | Jan 2, 2025 | Blogging, MS Access, MS Access VBA Coding, Versioning
I was watching this YouTube video by the Access Pacific User Group by Kent Gorrell. I was impressed with what he did basically building a version tracking system and amongst a slew of other things, built a system to automatically update SQL backends (with extensive...
by Jonathan Halder | Dec 30, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
Today, my Access adventure was a common story you hear every once in a while and almost all of us have experienced. I was finishing up some code it had taken me about an hour to write and I selected Debug->Compile from the VBE menu. The little blue progress bar...
