Office Solutions

2 Methods to Batch Delete All Contacts without Email Address in Your Outlook

If you find some contacts have no email address in your Outlook, you may want to process each Contact folder to delete all such contacts. This post will share 2 means with you. Perhaps you have many contacts in your Outlook and some of them do not have email address. If you think that they are no longer useful, you must hope to delete all the contacts without email address. In the standard way, you can use "Instant Search" to find them and then delete them manually, like the following Method...

Read more »

How to Implement Conditional Formatting in a Continuous Form in MS Access

In this article, we explain the steps for applying conditional formatting to a Continuous Form Conditional formatting as the name suggests is the kind of formatting that can be undertaken only when certain conditions are met. This is the kind of formatting that can be used for changing the background or the foreground color of the textbox controls that are a part of our forms or reports being used. To change the color of a single or multiple fields the values need to meet certain conditions;...

Read more »

How to Use Temporary Tables for Negotiating Non-Updatable Queries in MS Access

In this solution, we look at a non-programmatic way to deal with non-updatable queries in MS Access using Temporary tables  Queries in MS Access are one of the essential features provided by the application. If you take away the query feature from MS Access, there would be very little left in the application. Access provides its users with multiple types of queries that can be used in multiple situations. However, these queries also have their own set of limitations. The most annoying one...

Read more »