merge · Microsoft Access · Microsoft Word

WORD MERGE MANY LETTERS TO ONE IN WORD FROM MICROSOFT ACCESS

Say you have several letters you want to do in WORD and your list of contacts is in Access. Here are the instructions to create one document with all the letters but you input numbers into Access to specify which letter will be used. Create new field in Access where you will put numbers in… Continue reading WORD MERGE MANY LETTERS TO ONE IN WORD FROM MICROSOFT ACCESS

Microsoft Access

Microsoft Access can’t find the database file….Make sure you entered the correct path and file name.

You have a split database, end users can’t access the database because you’re getting an error message saying Microsoft can’t find the back-end file even though you know it’s in the folder it’s listing! Besides making sure the end users have the proper permissions to the folders, the problem could be that the users do… Continue reading Microsoft Access can’t find the database file….Make sure you entered the correct path and file name.

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