 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2004Template and multiple parameter query prompts
I saved my mail merge main document as a template. When I create a new document based on the template, the Microsoft Access parameter query prompts me TWICE, once for the template and once for the new document. How can I create the document with it only prompting me ONE TIME? Hi Lyn, > I saved my mail merge main document as a template. When I > create a new document based on the template, the Microsoft > Access parameter query prompts me TWICE, once for the > template and once for the new document. How can I create > the document with it only prompting me ONE TIME? Version of Word? Is Access also opening twice? How do you know it's the template that's causing the second prompt? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Cindy, Thanks for your reply. Word version 2000. Access (version 2000) IS opening twice when I open a new document in Word using the template. I didn't realize that - but still I don't know what to do about it. I am guessing that the reason for the prompt is once for template and once for document, since when I open the template only (using file, open), it only prompts me once. Also, when I open the template, Access only opens once. >-----Original Message----- >Hi Lyn, [quoted text clipped - 20 lines] > >. Hi Lyn, > Thanks for your reply. Word version 2000. > > Access (version 2000) IS opening twice when I open a new > document in Word using the template. I didn't realize > that - but still I don't know what to do about it. > Right, thanks for confirming this. What you're running into is a common problem, unfortunately, that has to do with the DDE connection required to use parameter queries. Word actually carries on a "coversation" with the Access application interface. And if it can't "recogize" Access's presence, it will open Access and the data base again each time it "telephones". One common cause of this is changing the Access title bar to show a more "friendly" name than "Microsoft Access". Did you do this, by any chance? > I am guessing that the reason for the prompt is once for > template and once for document, since when I open the > template only (using file, open), it only prompts me once. > Also, when I open the template, Access only opens once. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Cindy, Thanks for continuing with me on this. That was helpful. I changed the title_bar for the database back to "Microsoft Access". Now it no longer opens twice, however, it still prompts me twice for the parameter, once when the template opens and once when the document opens. Any other thoughts? Lyn >-----Original Message----- >Hi Lyn, [quoted text clipped - 32 lines] > >. Hi Lwyatt, Are you the only person who's going to be using this? Or is this a group or company thing? And is there any policy about using macros? (I'm trying to guage "security" vs. "ease of use") > I changed the title_bar for the database back > to "Microsoft Access". Now it no longer opens twice, > however, it still prompts me twice for the parameter, once > when the template opens and once when the document opens. > > Any other thoughts? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Cindy, I am creating this for several other people to use. Ease of use is our current concern. There is no policy about using macros. Thanks for your continued help. Lyn >-----Original Message----- >Hi Lwyatt, [quoted text clipped - 21 lines] > >. Hi Lyn, > I am creating this for several other people to use. Ease > of use is our current concern. I'm sorry, "real life" got extremely busy here, a few weeks ago, and I'm only just beginning to catch up in the newsgroups. Are you still here and looking for help on this? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
|
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.