 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Can Query fields be used in Super Easy Word Merge?
In Albert Kallal's WordMerge, will it work only with fields from tables, or can it pull from Query fields as well? And if so, does it have to be set up any differently... how do you tell it you want Query fields rather than Table fields? Thanks Little Crow well if you used Access Data Projects then you could use calculated fields in a table > In Albert Kallal's WordMerge, will it work only with fields from tables, or > can it pull from Query fields as well? And if so, does it have to be set up > any differently... how do you tell it you want Query fields rather than Table > fields? > Thanks > Little Crow yes, you can use any sql you want: eg: MergeAllWord ("select * from tblCustomers where city = 'Edmonton'") or MergeAllWord ("name of query goes here") The only bad limitation is that the query can't have parameter prompts. but, as above you can see how you can add you own parameters. The options are explained here: http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html The above options lets you specify the template, or even to print, or save the merged document to output name of you choice.  SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com Albert - Thanks for your response. I have used WordMerge for something like 100 docs with great success but all of the mergefields have been in my tables so it has been nice and easy to find them via the field list on the toolbar. But how would I find and select a query field (possibly a calculated field) to go into a mergefield on a template...I don't understand this bit, could you please clarify. Many thanks > yes, you can use any sql you want: > [quoted text clipped - 15 lines] > The above options lets you specify the template, or even to print, or save > the merged document to output name of you choice. > Albert - > Thanks for your response. [quoted text clipped - 7 lines] > you please clarify. > Many thanks Well, you can simply fire up the query builder, build you sql you want. Then, simply behind a button you can go MergeAllWord "NameOfquery" Also, in the download sample, there is a for that displays queries...and you can select that query for merge.... That form is named "what query". The choice of allowing the user to select a query, or just placing a button on a form is really up to your imagination, and how you want to present this to the end user.... SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.