Word Access Query Mail Merge help

[jasonrbaxter]

I am using Access 2003 and Word 2003

I am successfully using mail merge with an access query as my data
source but I'm not sure how to include related records from other
tables and insert them in separate lines of the word document.

I want to include on the same page another connected table that have
multiple entries

For example:

RCA # _____________

Date: ______________

Technician's Name:_____________

Problems: Steps to complete
1. ______________ _______________
2. ______________ _______________
3. ______________ _______________

RCA#, Date and Technician are one table
Problems and Steps to Complete are connected to the other table.

Each RCA form has one or more problems.

Right now I have a form that has a print button. When I press the
print button it takes the current record and creates a table (or
overwrites it). It then through VBA opens Word with our existing form
where I have the various fields connected through the data source of
that newly created table. I then open the data source and show the
merged fields.

When I'm doing this it will only show one problem because it is a basic
join query. I need to make another query but I'm not sure what to do.


If you need any more clarification I'll be more than happy to give it
as this is complicated to explain.

Thank you,

Jason Baxter

 

[Duane Hookom]

There is functionality in Word that allows you to specify moving to the next
record. You might want to search a Word news group for this solution.

You can also use the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Jay]

I am using Access 2003 and Word 2003

I am successfully using mail merge with an access query as my data
source but I'm not sure how to include related records from other
tables and insert them in separate lines of the word document.

I want to include on the same page another connected table that have
multiple entries

For example:

RCA # _____________

Date: ______________

Technician's Name:_____________

Problems: Steps to complete
1. ______________ _______________
2. ______________ _______________
3. ______________ _______________

RCA#, Date and Technician are one table
Problems and Steps to Complete are connected to the other table.

Each RCA form has one or more problems.

Right now I have a form that has a print button. When I press the
print button it takes the current record and creates a table (or
overwrites it). It then through VBA opens Word with our existing form
where I have the various fields connected through the data source of
that newly created table. I then open the data source and show the
merged fields.

When I'm doing this it will only show one problem because it is a basic
join query. I need to make another query but I'm not sure what to do.


If you need any more clarification I'll be more than happy to give it
as this is complicated to explain.

Thank you,

Jason Baxter

Try creating the two tables and place them in a query. Make a "problem id"
for the primary key in both tables. You have to have a uniq number for each
problem with the techs name with the solution. In the relationship select
enforce referential integraty with update and delete capabilities for both
problem ids in the tables. It is very tricky. You will have to make sure
that both tables have the same ids or you may get some weird error. If you
make it you should be able to delete, add and update the query directly.
That is the goal you want. You then make a form and use this query for the
control source.

Now merge the fag..err uh query to the word document. Now you should be
able to click on the pencil icon thingy and filter for what you want,
mainly the techs name with the problem and solution records related to that
techs name only.

In the word doc make sure you have a line of cells with the field names
merged into them and insert a next record at the end of the row of field
names. This will step through each record sequentially. Now select and
copy the row of cells and paste as many as you want. If you but
a next record at the end of the very last field name you will flow into
another page which is very cool. If you don't want another page just don't
but a next record and word will stop at that last field name and you will
only have one page.

Merry Christmas