3 Ways to Set Different Watermarks for Different Pages in Your Word Document

In this article, we will focus on showing you 3 ways to set different watermarks for different pages in your Word document. By default, when we inert watermark into a Word document, all pages take the same style. However, there can be times when you will try to use different watermarks, such as different on odd and even page. Let’s say, you decide to insert one kind of watermark on odd pages and another one even pages. Only then, you will run into the following situation. You notice...

Read more »

3 Ways to Change Inline Pictures to Floating Ones in Your Word Document

In this article, we will present you with 3 ways to change inline pictures to floating ones in your Word document. As you may be aware, whenever we insert a picture into a Word document, it takes the “In line with text” wrapping style by default. In this way, a picture is considered as a large character, which makes us hard to move it around simply by clicking and dragging. Accordingly, we need to change these inline pictures to floating ones as to easily adjust their locations. As...

Read more »

How to Escape Quoted Strings for SQL Statement used in Database via Excel VBA

SQL Server uses pairs of single quotes to identify the start and end of a string. Inserting 'Mrs Brown's Boys' into a database table will fail since the three single quotes imply two strings, one of which is incomplete. An escape character is required for the apostrophe after Brown. This article explores the use of a customised VBA function to resolve this anomaly. This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google...

Read more »