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 Batch Send All Files in a Windows Folder via Separate Outlook Emails

If you would like to send all files in a Windows folder via individual Outlook emails to someone, you can use the method introduced in this article. It is making use of VBA code, which is quite effective. After reading my previous article – “3 Quick Methods to Attach All Files in a Local Folder to an Outlook Email”, some users want to send all files in a local folder via separate emails. In standard fashion, you should create emails and attach the files one by one. It’s quite troublesome....

Read more »