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
So many times I needed to do maintenance on the database then update the frontend but couldn’t because other users had it open. Well, I finally found a fix! Now I can give the users a warning before the database closes on them. Here’s how: Go to this site and download the file. (Scroll down… Continue reading MS Access – Knock Users Out of Database
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.
I’ve got to give all props to Graham Mayor. His add-on was brilliant and did the job! If you need to have more than one record put on a Word document, based on a field’s value, Graham’s add-on is your solution. If you have several items that need billed to one account, for example, you… Continue reading Microsoft Access – Merge Many-To-One Records to Microsoft Word
This feature is used in a Microsoft Access form. You will create a hotkey, such as Alt+D, and no matter what field on the form you are in, it will drop-down the combo you set this up on so you can do a quick search/selection. Open the form you have created the combo box… Continue reading How to Add a HotKey to Combo Box Drop-Down
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
The following are the step by step instructions on setting up a drop-down GoTo feature on a form to search, select and go to a record quickly. 1. Set up a Query using the columns you want to see. Below is an example. 2. Type <>Nz([Form]![ID],0) in the criteria line of the ID column. Remember, the name… Continue reading Microsoft Access GoTo Feature