by Jonathan Halder | Dec 5, 2024 | Blogging, MS Access, MS Access VBA Coding
Error handling in VBA is crucial for managing runtime errors and ensuring your code runs smoothly. Here’s how it works in a couple of different common scenarios: Standard Error in a Single Procedure:When an error occurs in a single procedure, you can use the On...
by Jonathan Halder | Dec 4, 2024 | Blogging, MS Access, MS Access VBA Coding
How do we deal with Error Handling in a library? This came up because of the NiceDlookup function I’ve published previously. In that function, the Err object is used to “Raise” errors. The reasoning behind this for this particular function was to...
by Jonathan Halder | Dec 3, 2024 | Blogging, MS Access, MS Access VBA Coding
If you have a project you are working on in Access and are looking for another pair of eyes or some advice on how to work through adding a new feature to your system, you might find pair programming a valuable asset. In order to pair program, you have a few options....
by Jonathan Halder | Dec 2, 2024 | Blogging, MS Access, MS Access VBA Coding
Have you collaborated on an Access database with others? I’d like to do more of this personally. I think sharing experiences of coding with others in terms of pair or mob programming would be fun, informative, and helpful for all involved. Pair or Mob...
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...
by Jonathan Halder | Nov 26, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
Some things you do when designing forms inherently reset the VBA environment. This takes all your existing object variables in that form and resets them. That’s why I often use a function to refer to an object to check to make sure it exists before I use it so I...
