February 2020
What Is The Access VBA NZ Function
The Access VBA NZ function allows you to test for values with zero length. It is unique with Access, as far as I know, no other language has this type of function, and you’ll have to make your own. If you want to check if a variable is blank, you should check the length (contents) […]
How To Use Access VBA To Copy A Table With DoCmd.CopyObject
This post was actually inspired by a question I received from this site’s chatbot. In this post you will find how you can use Access VBA and the DoCmd.CopyObject method to copy a blank table, and append the value of a combobox to it. The database has just one blank table “tblFacilityBlank”, that we’ll copy […]