- Local time
- Tomorrow, 07:03
- Joined
- Jan 20, 2009
- Messages
- 12,832
Chris's advice re error handling aligns with my own. I usually add error handlers at the end using MZ-Tools (a free and must have tool for every VBA developer) and comment out the On Error line for later rework.
Chris's suggestion about using a constant should be taken a step further if you want to persue that technique.
Investigate conditional compilation. It is special type of If statement that only includes the True branch when the code is compiled. This ultimately results in more efficient code on the production database.
Chris's suggestion about using a constant should be taken a step further if you want to persue that technique.
Investigate conditional compilation. It is special type of If statement that only includes the True branch when the code is compiled. This ultimately results in more efficient code on the production database.
