Bagi anda yang sering berhubungan dengan MySQL database dan Microsoft Access database, kedua jenis database ini bisa saling “berkomunikasi” dengan baik. Kita dapat dengan mudah import data dari MySQL ke MS Access ataupun sebaliknya. Agar kedua program ini dapat berkomunikasi,… Continue Reading
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
I was looking around the internet to find a better way to calculate time difference between two values on my MS Access Table. And finally I found a good solution on how to calculate time difference that works over 24… Continue Reading