Excel Visual Basic modules require triggers to initiate. They can be initiated by using CTRL + combination shortcut keys, clicking a button, or simply pressing an ENTER key. I normally shun the use of CTRL + combination shortcut keys because it is not user-friendly. It requires the user to remember what keys to be pressed … Read more Press ENTER key to trigger a Visual Basic Module
You might have seen that your Access database file keeps on growing in size, even though you have not been putting in many new data. This is caused by the way how a database is structured. For all the database software that I used before, the database software leaves an unused section every time you … Read more Compact your Access database to keep it small and improve its performance
Both the WORKDAY and NETWORKDAYS functions are essential for project planning. The WORKDAY function allows you to calculate the completion date provided that you know the number of days that is required to complete the project. The NETWORKDAYS function does the opposite. You have a desired completion date and you want Excel to calculate how … Read more WORKDAY and NETWORKDAYS Functions
Your Microsoft Access files are initially created in MDB or, with Access 2007 or after versions, in ACCDB format. In MDB or ACCDB formats, everyone can have access to your Visual Basic modules. Users can maliciously or accidentally change your codes and make your VB modules inoperable. To protect the integrity of your Access files, … Read more Hide Visual Basic Modules by saving your Access Files in MDE or ACCDE file format
You may want to include simple calculations in some of your Word documents, notably Quotes and Invoices. Ideally the quotes and invoices are generated from an Accounting system. But for a lot of small business owners, Microsoft Excel may already be their Accounting system. I have seen many small business owners use a calculators to … Read more Embed an Excel Object into Microsoft Word Document
Quick Launch Bar is a wonderful tool to enhance your efficiency. It’s more convenient than placing your frequently used applications on your desk top. It is easy to put applications to the Quick Launch Bar. You just need to drag-and-drop the icons to the Quick Launch Bar. Besides putting the application icons from your desktop … Read more Creating a Quick Launch Bar in Window to enhance your efficiency
I was once a part time interpreter about 20 years ago. I went to court houses, law firms, hospitals, and insurance companies to do instant verbal translations and document translations between Chinese and English. It was not an easy job but it paid well. The requirements of an interpreter are very high because you need … Read more Use Translator in Microsoft Office to translate documents
When we automate the Excel worksheets by using Visual Basic (VB) codes, we frequently have to make the cursor moved to pre-determined locations to do calculations, copy, cut, paste, sort, and filter data. If you know how to combine the movements with the looping, you have an ultimate tool for automation. The payoff is tremendous … Read more Navigate around cells, worksheets, and files by using Visual Basic Codes
Internal Rate of Return (abbreviated as “IRR”, also called “Yield”). In this article, “Internal Rate of Return” “IRR”, and “Yield” will be used interchangeably. IRR is one of the most important tools in the financial world. It measures how well an investment or a project performs over time. It is an essential part of benefit/cost … Read more Internal Rate of Return (IRR) Calculations with different Accrual Basis
Ideally, all the reports should be generated from the system itself. However, we are living in a world with limited resources. The IT Department always has different priorities from you. Your urgent request may turn out to be the lowest priority of your IT Department. If you don’t know how to do some programming yourself, … Read more Use ODBC to connect Oracle Database and Microsoft Access