A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2003 merge to Word 2003 - multiple questions



 
 
Thread Tools Display Modes
  #1  
Old June 9th, 2006, 04:26 AM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 04:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.