Greetings Access Wizards,
I thought I'd be clever and setup an Access Database for some of my less Excel savvy co-workers to create there own Table that could be used for mail merge letters in Word. I've never fooled with Access much but I figured it couldn't be much different that Excel. I figured incorrectly. Access is a beast to understand.
Let me be clear, I know little to nothing about VBA or Table Relationships. However I managed to come up with a "Order Form" that does complete an "Order Table" that displays everything I need for the mail merge. However, when I use that table for Word's Mail Merge, some of the data displays the Primary Key rather than the pulled data from the other tables (Names, Addresses, Phone numbers). If I export the table to Excel it works fine and all the proper data is displayed in the fields. But I'd rather be able to get the mail merge from the Orders table.
I did use code builder to auto-populate the Form with the information from the customer table (names, addresses, phone) based off the client number from a combo box. The Client ID combo box had all the other fields as well but I shortened the width so they were un-noticable from the drop down. The other fields are also in the form as combo boxes with only the field required (First name for example). So when I type the Customer Number the rest is auto-filled and if changes are needed to those fields on the order form a button to open the customer form is used.
Since my finding the mailmerge problem, I've read some folks say that the Mail merge doesn't work well with Word, which would be quite devastating considering the 20 hours I've lost on this thus far. With my little understanding of the table relationships, I'd hate to try to go back through this thing and try to untangle the webs, so I'm hoping that isn't the issue. I've tried to create a Query but I'm lost there as well.
Any suggestions on a simple way to get mail merge working that won't take extensive knowledge??
Thank you for your time in looking at this.
This is my code if you think it's the issue.
Code:
Private Sub CLMTID_Change()
Me.CLMTFN.Value = CLMTID.Column(0)
Me.CLMTLN.Value = CLMTID.Column(0)
Me.Blank.Value = CLMTID.Column(1)
Me.CLMTADD2.Value = CLMTID.Column(0)
Me.CLMTCITY.Value = CLMTID.Column(0)
Me.CLMTSTATE.Value = CLMTID.Column(0)
Me.CLMTZIP.Value = CLMTID.Column(0)
Me.CLMTPHONE.Value = CLMTID.Column(0)
Me.CLMTEMAIL.Value = CLMTID.Column(0)
Me.CLMTLODGE.Value = CLMTID.Column(0)