by Jonathan Halder | Jan 9, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I had written some code for a client using the onChange and onKeyPress events of a ComboBox to be able to determine when the user had simply typed some text in, or whether they had selected an item from the dropdown list using the dropdown event. This was because the...
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...
