connect to an Access form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry - 03 Jan 2004 08:01 GMT

I'm wondering if a Word 2000 or Word 2002 mail merge document can
somehow connect to a form in an Access database. After choosing a
selection in the form, a query would then run which would send the
results back to Word.

Barry

Reply to this Message

Peter Jamieson - 03 Jan 2004 09:11 GMT

Word can only connect to a table or query. In the situation you describe you
probably need to consider initiating your merge from a button on your Access
form, creating the data source that you need, perhaps by populating a table
in the database (probably difficult to get that right in a multi-user
scenario) or exporting the relevant data to another file/mdb and using that
as the data source.

--
Peter Jamieson - Word MVP
Word MVP web site http://www.mvps.org/word

> I'm wondering if a Word 2000 or Word 2002 mail merge document can
> somehow connect to a form in an Access database. After choosing a
> selection in the form, a query would then run which would send the
> results back to Word.
>
> Barry

Reply to this Message

Cindy M -WordMVP- - 05 Jan 2004 17:49 GMT

Hi Barry,

You'd need to use VBA code for this. The WdAcc97.zip file you'll find
in the Special Merges section of my website's mail merge FAQ has, as
best I can recall, the bare bones you'd need to get you started.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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

Barry - 07 Jan 2004 02:46 GMT

> Hi Barry,
>
[quoted text clipped - 14 lines]
> This reply is posted in the Newsgroup; please post any follow
> question or reply in the newsgroup and not by e-mail :-)

Cindy, I've downloaded the WdAcc97.zip from your site and am going to
try to see if I can understand it. I'm totaly new to database
programming.

Thanks.

Barry

Reply to this Message

Cindy M -WordMVP- - 07 Jan 2004 11:12 GMT

Hi Barry,

> I've downloaded the WdAcc97.zip from your site and am going to
> try to see if I can understand it. I'm totaly new to database
> programming.

Understood :-)

Cindy Meister

Reply to this Message

Barry - 08 Jan 2004 04:17 GMT

> Hi Barry,
>
[quoted text clipped - 5 lines]
>
> Cindy Meister

Cindy,

As I am playing around with your code, one question comes to mind.
The Mail Merge main document consists of a page of labels and
Mergefield codes. If I wanted to add a drop down list of 2 fields
from an Access database table into the document, where would I put it
on the page? The selection from that dropdown list would be passed to
a query which would return the results to a separate Word document.

Barry

Reply to this Message

Cindy M -WordMVP- - 08 Jan 2004 10:49 GMT

Hi Barry,

> As I am playing around with your code, one question comes to mind.
> The Mail Merge main document consists of a page of labels and
> Mergefield codes. If I wanted to add a drop down list of 2 fields
> from an Access database table into the document, where would I put it
> on the page? The selection from that dropdown list would be passed to
> a query which would return the results to a separate Word document.

Maybe it's because my brain is fuzzy, but I'm not following exactly what
you have in mind? Can you try a somewhat more verbose description, and
very carefully distinguish what kind of thing would be where?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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