Office File Recovery

How to Easily Use Controls in Subforms in MS Access

The article explains the uses of Subforms in multiple controls on multiple forms and how to acquire information using subforms. Subforms are useful tools in dealing with relational data in tables in Microsoft Access. They allow users to control multiple forms or Queries using a many side relationship. A subform, as the name suggests is part of a main form, and is a part of it. The article will explore the uses and functioning of Subforms in MS Access. Subforms in MS Access Subforms are the...

Read more »

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 Use IsVisible and HideDuplicate Properties to Hide Duplicate Fields in MS Access

IsVisible and HideDuplicate property allow the user to hide the duplicate and repetitive fields in Microsoft Access but there is a small difference between the two. The article sums up the functioning of these two properties. MS Access is one of the reliable solution for managing databases in small and midsized firms. A common problem faced by users of Access databases is the unnecessary repetition of records in text fields. It can however be dealt with IsVisible property. The Duplicate...

Read more »