February 18, 2015 at 2:39 am
Hi I have an access .adp project which is linked to a sql server tables (2008 r2), I have a button on an access form which I click and successfully gets customer details based on a query. What I wanted to know is when I am viewing a specific record i.e. details for Patient Number X, when I click on a mail merge button from their record form can the mail merge document only open with their details not all customers?
thanks
February 18, 2015 at 11:07 am
I presume you are referring to a Microsoft Word mail merge document that is being merged using some VBA code. Unfortunately, doing that from a .ADP project appears to be rather challenging technically, and reported to not be terribly reliable, but isn't something I have personally done. However I do have substantial experience with doing merges from .MDB format Access databases using SQL Server back-ends, and I would suggest that you consider the alternative of Automation to do a single document, using a Word template and bookmarks in Word to populate the data from the form. The link Automation 101 can be used as a starting point to explore Automation. Many of the references are rather dated, but the concepts are still valid.
The other option is to use a report within your ADP project, but the formatting options available on reports aren't as powerful as you have with Word. If you are trying to create a document that is more like a letter, then Word is the better choice.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply