Office File Recovery

How to Hide the Ribbon when You Launch MS Access

In this article, we learn the process of using USysRibbons Table for creating customized ribbon and the applying it while launching Access. Having Ribbons in your MS Access application helps greatly when you need to make use of all the tabs that are present on the ribbon. But at times there can be situations when you need to prevent the tabs on the ribbon from appearing at the time of launching the application. The process of hiding the ribbon or loading one without any tabs has not been...

Read more »

3 Interesting Facts about Null Values in Access that You May Have Overlooked

In this article, we look at the 3 most commonly overlooked facts about Null values. Nulls in MS Access form one of those tricky concepts that even a lot of Access experts have problems dealing with. Understanding Nulls is not a problem if you understand what are ‘not nulls’. That is an easier approach to understanding them. So instead of trying to focus on what are Nulls, you should focus on what nulls are not. But for those who are still looking for a conventional answer, you can...

Read more »

Understand Cascade-to-Null Feature and How it Can Allow the Use of Null Foreign Key

Here we understand the Cascade-to-Null feature in MS Access and how to use it for allowing Null values in foreign key fields. Indexed fields in MS Access are usually not Nulls mainly because the fields have been set with a ‘Required’ property, to ensure that there are values entered for all fields, irrespective of the data type. But as the case maybe there can be situations where having a Null foreign key can actually be of some help. An example can be of a situation where you need to...

Read more »