Hessel de Walle's Blog

Introduction When I create object in Access I try to be as consistent as possible. For instance, when I create a table containing customers, I create names like this: Object Name Table tblCustomers Form frmCustomers Query qryCustomers Command button cmdCustomers It is not just that I like the Hungarion Notation (invented by Simonyi Károly from Hungary), it also enables me to use smart functions while programming VBA . Smart Functions For instance when I create a command button which should lead me to the form frmCustomers , I call the command button cmdCustomers . After that I attach a function to the On Click event: Because it refers to the active control, it will automatically transfer the name of the command ( cmdCustomers ) tot the function cmdCommandClick . The VBA of the function  cmdCommandClick  looks like this: Public Function cmdCommandCl...