Solutions

Why One Should Avoid Using Memo Fields for Grouping in Access

In this article we would learn the key aspects related to memo fields and learn why they are not really helpful and often result in bugs and truncation. A memo field can store large amount of information, allowing up to 65,536 characters, with various options. In the latest editions of MS Access, it can store up to 1 GB of characters and allows rich text formatting. But it is often suggested to avoid the use of Memo fields for purpose like grouping in MS Access. The article will discuss the...

Read more »

How to Quickly Find the Contacts without a Photo in Your Outlook

Outlook doesn’t provide search filters that can support users to find the contacts that don’t have photo. Thus, if you wish to quickly search out the contacts without a photo, you can use the method shared in this article. Some users would like to quickly find out all the contacts that don’t contain photo. Yet, by default, Outlook doesn’t offer such a native search filter. Hence, you have to create such a filter in the first place. You could use the piece of VBA code below to achieve...

Read more »

How to Quickly Export the Statistics of Appointments in a Specific Period via Outlook VBA

If you want to count the appointments per day in a specific date range and export the results to an Excel file, you can use the smart way introduced in this article. It can accomplish this in quick time. Sometimes, you may need to count the appointments per day. Of course, you can choose to count manually. However, it is still a bit troublesome and error prone if there are too many appointments in your calendar. Hence, you had better search any more effective means, such as the following...

Read more »