Access Database Recovery

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 »

How to Number Records in Your Access Forms and Reports to Make Them More Organized

Numbering is one of the easiest ways of organizing data and in this article we apply the concept to on Access Forms and Reports Numbering or ranking data plays an important role in keeping records sorted and organized. And people often prefer arranging their Access reports and forms with numbering entries to gain an easy access to a particular subject. Numbering entries also come in handy if the user is looking for a particular range data. These steps can be used by casual as well as...

Read more »

How to Deal with “Can’t Append All Records in the Append Query” Error in MS Access

In this article we examine scenarios which generate errors relating to failure to append records in MS Access In MS Access, an append query is used when a user updates some records to an existing table, usually from other sources.  Append query basically selects new records from other sources of data and copies them to the table in database. It is helpful in appending multiple records at once and it also allows the user to refine the selection with certain criteria. Users can review the...

Read more »