If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 merge to Word 2003 - multiple questions
Hello, I've been searching the newsgroups for these answers for days
but have run out of time. Any help would be appreciated. How can I merge a query based on only the current record displayed on an Access 2003 form to a Word 2003 mail merge file? This article helped http://support.microsoft.com/?id=209976 . When I add a WHERE clause such as the following, the query is no longer available as a data source to Word: WHERE ((Orders.OrderID)=[Forms]![OrderForm]![OrderID]); In the MergIt function (above, from Microsoft), can OpenDataSource limit the query to the current record? Currently, it only uses: Connection:="QUERY qrySamplingRequestForm" Could I use SQLStatement as "Select * WHERE OrderID=Form!OrderForm!OrderID" ? Then, I need to translate evil lookup table values from Access to look good in Word. What is the SQL code to do the lookup that these tables do automatically? ie: Orders table stores MuniCode number which coresponds to a name in the Muni table. How to translate that number to a name in the SQL mailmerge population query? Last, I need to add calculations and conditionals to my query, ie: outputting either a database field or text constant based on the field value. Should these calculations and conditionals be in the SQL query, and if so, how does that look? Or should they be in VB code which creates a VB query, and if so, how can I base a Word query on a code-generated query? Or should they be in the Word document using IF mergefields like this - http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm , though this is very inflexible. Thank you very much for your help. Newsgroups have helped me create a very functional database from scratch with no Access knowledge, and I am very grateful. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
take yet another lesson from wordperfect "reveal codes" | wordperfect is superior | General Discussion | 5 | May 11th, 2009 07:58 PM |
How to put graphics on envelopes? | Steve Koenig | General Discussion | 20 | September 14th, 2007 04:40 PM |
WP merge file to Word | sstires | Tables | 4 | February 14th, 2006 06:26 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |