Office Solutions

7 Mistakes to Avoid while Creating Reports in MS Access

When we create reports in Ms Access, it is quite common for some of us to make inadvertent mistakes. In this article we try to identify such mistakes and rectify them. MS Access is considered to be the best tool for generating reports amongst desktop databases. It not only helps generate comprehensive reports, but also provides user friendly tools for creating a report. Often while creating a report, there is a possibility that one might end up making mistakes, which can lead to errors in...

Read more »

3 Useful Tips to Secure Forms and Codes in MS Access

In this article we look at ways to secure Forms and Code we use in an Ms Access Application There are multiple options available to an Access user for securing the design of their forms, reports, codes, etc. One might attempt to make use of the permissions for securing the two, but it is important to note that Visual Basic is not supported by permissions. You can prevent users by looking at your forms and code designs by not removing the Read Design and The Modify Design permissions. By...

Read more »

How to Auto Update the Associated Group Member when Changing a Contact’s Email Address in Outlook

By default, when you modify a contact’ email address, the email address of the contact group member corresponding to this contact won’t change accordingly. So, this post will share a way to realize “auto update member” with utmost ease. The main reason why you change a contact’s email address is generally that the original email address is not useful any longer. Thus, when you change a contact’s email address, you had better modify the email address of corresponding contact group...

Read more »