Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access parameter query not visible as data source in Word
Hi all,
I'm working with an Access .mdb that consists of numerous SQL server attached tables. I constructed a parameter query that selects the data/fields that I'm interested in and in Access the query works fine. Problem is, when I go to Word and try to select/use the query as the data source for my mail merge doc, I can't see it on the browse list at all. To further confuse my pea brain, when I remove the "parameter" criteria from the query in Access and re-save it, Voila, I can see it on the Word side; but which also makes it useless as a data source that selects a specific record based on the criteria.... I've done this exact thing before, although not involving SQL server attached databases, so I know that in principle, it works..... Does anybody have any insight regarding this behavior?? TIA!! Cal p.s.- I'm using Word 2002 and Access 2002 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access parameter query not visible as data source in Word
Thank you!!!! I "accidentally" stumbled across your suggestion whilst
surfing some other newsgroups....may even have been one of your posts....and you're *exactly* right. It works. Yippee!! Thanks!! "Doug Robbins - Word MVP" wrote: For starters, why not initiate the mailmerge from Access? You do that, selecting the query in Access and then from the Tools menu, select Office Links and then Merge it with Microsoft Office Word. As an alternative, from the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, select the DDE option. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "drivingme crazy" drivingme wrote in message ... Hi all, I'm working with an Access .mdb that consists of numerous SQL server attached tables. I constructed a parameter query that selects the data/fields that I'm interested in and in Access the query works fine. Problem is, when I go to Word and try to select/use the query as the data source for my mail merge doc, I can't see it on the browse list at all. To further confuse my pea brain, when I remove the "parameter" criteria from the query in Access and re-save it, Voila, I can see it on the Word side; but which also makes it useless as a data source that selects a specific record based on the criteria.... I've done this exact thing before, although not involving SQL server attached databases, so I know that in principle, it works..... Does anybody have any insight regarding this behavior?? TIA!! Cal p.s.- I'm using Word 2002 and Access 2002 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cant find an Access query which is a Word data source when I tr. | Mailmerge | |||
Access query as a mailmerge source | New Users | |||
mailmerge from Access parameter query only merges odd records | Mailmerge | |||
AN SQL query as a data source for a word MAIL MERGE | Mailmerge | |||
Data Source query concerning Works when using Word | Microsoft Word Help |