I never use IsNull() because a seemingly empty value could be a zero-length string or even a string of spaces. So I prefer to use Len(Trim(Field1 & "")) = 0 to take all such possibilities into account. And that has become my habit since the beginning. I know Access makes things easy and automatically turns an empty textboxes into null. But if you ever import data from other people's databases, you just can't assume all their empty fields are null. Your code will need to check for everything: nulls, zero-length strings, spaces, etc.
@599CD2 жыл бұрын
Interesting. Thanks for sharing. :)
@tomthumb30852 жыл бұрын
Very handy tip thanks Richard. I have a question that you may be able to answer, which has been troubling me: how do I assign a “click” to a button press in my database please.
@599CD2 жыл бұрын
Watch this: 599cd.com/VBA
@moodkn2 жыл бұрын
Great Sir !
@599CD2 жыл бұрын
Thanks
@alfredbanda63852 жыл бұрын
great sir i like it
@599CD2 жыл бұрын
Thanks for liking
@alfredbanda63852 жыл бұрын
am thank you Mr Richard
@599CD2 жыл бұрын
Welcome
@manoj93512 жыл бұрын
Sir can u plz help me in my project of ms access invoicing software when I enter the product in subform all other fields like mrp rate tax percentage is auto populated I create calculated fields ofr this. And use dlookup but all these things are working in accessform not update in table
@599CD2 жыл бұрын
599cd.com/ASK
@nabeeljakway87932 жыл бұрын
Thanks
@599CD2 жыл бұрын
Welcome
@balaboopathy12282 жыл бұрын
Not able to find the join button . Please help
@599CD2 жыл бұрын
It might not be available in your country. You can join on my web site at 599cd.com/THM
@SkepticleOrc2 жыл бұрын
Is making my database an ACCDE file the only way to prevent people from accessing the [background] ? I recently made a database, had log ins, user permissions, the whole shazam. chKey was deactivated. I turned all the menus off and I was convinced it was no longer accessible. But after a little research, all I had to do was rename the file, press and hold the shift key whilst the database opened, click the X on the macro warning. After that, you can access the privacy options, set the load form to nothing, reload it and bam. Everything showed up.
@599CD2 жыл бұрын
A properly designed ACCDE file will not let you access form design. Period.