Microsoft Word

Suppressing Blank Lines in Address

Microsoft Word – Suppressing Blank Address Lines   On your Word document, put your cursor where you’re inserting your first field. Then go to the MAILINGS tab and click “Insert Field”. To Toggle back and forth to see this formula, highlight all of the section you want to see (it’s ok if you highlight more)… Continue reading Suppressing Blank Lines in Address

Microsoft Access · Microsoft Excel · Microsoft Word

Mail Merge Many-To-One Add-In

This is one of my favorite Word add-in I came across trying to solve a problem I was having. I had an Access database where I wanted to create invoices. I’ll make up an example because mine’s a little harder to explain. Say you have a construction job and everything you purchase you apply to… Continue reading Mail Merge Many-To-One Add-In

Operating System

Looking For Help to Create Operating System Using Containers

Why you should help me create the next operating system (using containers) People have the capacity to manage about seven units of information at a time in their working memory. Computers can help us with tasks that are complex and relieve cognitive load; however, they can also tax our working memory when one has to… Continue reading Looking For Help to Create Operating System Using Containers

Microsoft Access

Calculating Age using Date of Birth

Creating field in form To add a field that will calculate a customers age using their date of birth: Open up the form you wish to add the field. Under the HOME tab, click on the “View” drop-down option located in the ribbon on the far left and change to “Design View”. Insert a “text”… Continue reading Calculating Age using Date of Birth

Microsoft Access

Microsoft Access Joining Names with Expressions

In this post I will show you how to join customer names (customer plus spouse) and customer salutations. This is very useful when doing Microsoft Word merges into form letters. Open up the Query that you want to create a field for joining customer names and salutations. You will need the customers first name, last name, salutation,… Continue reading Microsoft Access Joining Names with Expressions