by Jonathan Halder | Dec 10, 2024 | Blogging, MS Access
There are a few strategies you can use to extend the life of Access and make the app available outside of a LAN. Utilizing Remote Desktop of some kind: One way is to use Remote Desktop services. I often just use a VPN to get into a particular LAN where Microsoft...
by Jonathan Halder | Dec 9, 2024 | Blogging, MS Access, MS Access VBA Coding
Pair or Mob programming is a collaborative technique where two or more developers work together at one workstation. One writes the code (the Driver) while the other(s) review each line of code as it’s written (the Navigator). Here’s how one might structure an...
by Jonathan Halder | Dec 6, 2024 | Blogging, MS Access, MS Access VBA Coding
Pair Programming and Mob Programming are collaborative approaches to software development that emphasize teamwork and shared responsibility. What is Pair Programming? Pair programming involves two developers working together at one workstation. One developer, known as...
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...
