Hello again! It’s been a long time since my last publication, but its better late than never. My topic today is how to improve database performance to make your application efficient. To be specific, we would be talking about database indexing. Normally we rely on the Primary Keys as the default index of the table. But in most of… Read More Indexing your MS SQL Database to improve performance
In MS Access, you will definitely encounter a #Deleted record tags in your MS SQL linked table when the table contains BigInt primary key as shown in the image below: To solve the problem, you need to create a view and cast the BigInt primary key to a VarChar then link the view and not… Read More How to solve #Delete records when linking BIGINT MS SQL Primary Key in MS Access?
Navigating your business in today’s market is not just hard but expensive. Aside from making sure that your business is profitable and sustainable through your product/services and customers, you have to pay taxes. As Benjamin Franklin would put it “In this world nothing can be said to be certain, except death and taxes”, therefore, the… Read More POS for your Business
Below are the steps to highlight a record in a continuous form without writing a class. 1. Make a continuous form and fill it with transparent background controls. Make sure that the source of the table has a unique identifier, like an Id or some sort. 2. Add two hidden controls, one is the Id… Read More How to highlight a record in a continuous form?
When the customer requires you to be absurdly perfect, specially in exporting reports to Excel, the DoCmd.OutputTo object becomes utterly useless, because it throws a lot of garbage columns in your exported Excel file. It is also useless to export directly the table source of your report to Excel because it will disregard your subtotals. … Read More How to export Access Reports to Excel less DoCmd.OutputTo object?
Below is a sample code to upload Sales records from XLS file, which is downloaded from a different system, e.g., POS, etc.. In my previous blog, I already explain the XLS file transfer between two system but it needs more practical example and thus this new blog is written. There are several steps in uploading… Read More Uploading XLS file using VBA.
The Slaughterhouse/Production system of MMPC is Innosoft’s first fully integrated industrial information system, a system that includes machine and user entry. The system covers processes from receiving of livestock to packaging fabricated meat products. The process involves changing of material from one activity to another, for example, we received a live cattle at the… Read More Innosoft’s Slaughterhouse/Production System
Back in 1994 when we were writing database application on DOS operating system using Clipper language, users clamor for a better user interface, a windows interface, where they could use the mouse instead of a keyboard to execute a task, Microsoft Access was the nearest substitute, and the rest was history. Microsoft Access provides all… Read More How does it all started and where are we headed?
Most of my MS Access + MySQL clients have multiple branches. One of their requirement is to consolidate the transaction/database of their branches to the main office. My previous solution was to use FTP+MySQLDump, but now we have a better solution, the DropBox. The first step is of course to download the DropBox utility through… Read More How to update the Main Office MySQL database using DropBox?
It’s been a while since I’ve written about Microsoft Access. But today we shall discuss about it and its future UI designs. As you can see below, Microsoft Access adapts Windows 8 Metro style. I will be using this style for one of my client (Third Party Logistics Warehouse Management System) for Innosoft Solutions in… Read More Metro style UI for Microsoft Access Application.