User Profile
韩化妆品登黑榜 共有19批次韩国化妆品进黑名单
Copper Contributor
Joined 3 days ago
User Widgets
Recent Discussions
What's the cleanest way to skip NULLs when looping through Recordest in VBA?
I've been working on a legacy Access app, and I find myself looping through a DAO recordest to process a bunch of fields. The thing is , some of those fields occasionally contain NULLs, and I've noticed they can easily break logic when you're not careful, especially when doing string concatenation, arithmetic, or conditional checks. I'm doing something like this : If Note IsNull(rs!MyField) Then ' Do something with rs!MyField End If Which works, but when you've got multiple fields or are writing more compact logic, it starts to get messy real fast. I'm wondering. Is there a cleaner or more elegant way to handle or skip NULLs ? PS ; I am having issues with the code editor13Views0likes1Comment
Recent Blog Articles
No content to show