Invoke Word Mail Merge from Access2007

IntroductionMail Merge is a powerful feature in Microsoft Word for creating and printing form letters.  For example Employment Contracts with fixed employment terms, but with changing personal details, like name, address, basic pay, allowances, contract period, etc., can...

Read More

Copy Paste Data from Excel to Access2007

Introduction.Methods are already built into office applications to transfer data between them. Importing/Exporting data or directly linking to it while maintaining the original data in the parent application.  Transfer data into the Clipboard (Copy) and Paste them into...

Read More

User-level Access Security and Access2007

Introduction.User-level/Object-level Access Security in Access versions earlier than Access2007.  All my Microsoft Access Applications were secured with User-level/Group-level Security and it is so effective when applications are shared on a Network.  I have never...

Read More

Macros and Temporary Variables

Introduction.If you are using Microsoft Access 2007 or a later version of Access then there is something new for you. You can use the SetTempVar action in Macros to define Global Variables.  After that, you can use the values in those variables in another macro or in an...

Read More