Solutions

How to Improve Your Efficiency by Highlighting the Expiry Dates in Excel Worksheet

You will certainly input the task and the date plan into Excel worksheet. Here we will introduce a method to highlight those expiry dates to improve your efficiency. When you have many tasks to do, you can use the Excel to make your plans. However, with so many tasks to finish, sometimes you may forget one or two. The image below shows the test activities and the expiry dates in a worksheet. In order not to forget one of the dates, you can highlight those cells to remind yourself. Now...

Read more »

How to Prevent Error Messages in Reports in Older Versions of MS Access

If you are using an older iteration of Ms Access, Error Messages in Reports are fairly common. In this article we look to avoid them by performing some simple steps. Like it happens with many other applications and objects, the older editions become obsolete as the new and advanced ones take over. Also old versions of software are typically more prone to errors than current ones. In the 2003 and older editions of MS Access, an error message used to appear in reports if there was no record...

Read more »

How to Auto Check for Attachments in Specific Outgoing Emails with Outlook VBA

Sometimes, you may forget to add required attachments to specific emails, such as emails to report your weekly works. This article will teach you to activate a popup warning to prevent you from sending the specific emails without attachments. Unlike Outlook 2010 and previous versions, Outlook 2013 has a native support to remind you when you haven’t attached any files in the outgoing emails. You can enable this feature in Outlook Options like the following screenshot: As long as you...

Read more »