This is a note for my self when learning the VBA Access. I will show you how to open an Excel file (.xlsx) from Microsof Access Form using VBA. Its not hard to open a Microsoft Excel using VBA from MS… Continue Reading
In order to check if a Table exist on a Database (MS Access), we can use Function in VBA. Its pretty simple and I think most of you can easily learn and apply this on your own project. The idea… Continue Reading
I was trying to build a small system/procedure using MS Access which will import excel file to my MS Access database. The field or column inside the Excel file is vary from file to file. So here I need to… Continue Reading
Currently I am building a new Access database system which operates many forms and sub forms. I have a button which control a sub form. The following code will let a button to add new record to sub form using… Continue Reading