Access parameter query not visible as data source in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drivingme crazy - 22 Apr 2008 13:09 GMT

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 to this Message

Doug Robbins - Word MVP - 22 Apr 2008 13:25 GMT

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.

Signature

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

> Hi all,
> I'm working with an Access .mdb that consists of numerous SQL server
[quoted text clipped - 21 lines]
>
> p.s.- I'm using Word 2002 and Access 2002

Reply to this Message

drivingme crazy - 22 Apr 2008 13:46 GMT

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!!

> 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
[quoted text clipped - 30 lines]
> >
> > p.s.- I'm using Word 2002 and Access 2002

Reply to this Message