[drivingme crazy]

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

[Doug Robbins - Word MVP]

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

[drivingme crazy[_2_]]

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