Solutions

How to Deal with Unique Keys in SQL Server Replication Errors

Replication errors will have a key with which we should identify the missing row from the subscriber. We must then manually copy those records from Publisher and then insert into the subscriber. While doing this activity, we would have to turn off and turn on the identity column. In this article, we will learn how to deal with Unique keys in a replication. Missing data: Consider that you had initialized a subscription without a snapshot by using options like initialize with backup or...

Read more »

How to Work with Label Margins in MS Access

In this article, we have addressed how user can use label margins in MS Access A good designed and structured Report or Form is more likely to catch the eyes of the onlookers than a plain bland data record. All organizations, businesses, and programmers design them.  But the problem with assigning different people to design the same Report or Form is that they are going to design them according to their preferences and taste unless they are all using the same default wizards. Some users...

Read more »

How to Open Received/Sent Emails in “Edit” Mode Automatically with Outlook VBA

To change the body of a received or sent email in Outlook, you have to open it and then turn it into "Edit" mode. If you often need to make modifications in such emails, you'll wish to open them in "Edit" Mode automatically. This post will help you get it. At times, you may need to alter the content of a received or sent email in Outlook. In this scenario, as introduced in the previous post – "How to Modify the Subject & Body of Received Emails in Outlook", you have to open the email...

Read more »