connect to an Access form

[Barry]

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

 

[Peter Jamieson]

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.

 

[Cindy M -WordMVP-]

Hi Barry,

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.

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

 

[Barry]

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

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

 

[Cindy M -WordMVP-]

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

 

[Barry]

Hi Barry,

Understood

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

 

[Cindy M -WordMVP-]

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