Filling out a Word document

[spencer nash]

Hello everyone,
I've been racking my brain trying to figure this out and have hit a
wall. Hopefully someone has an idea for this situation.

I have a query that gives me a list of teachers and their students.
Each teacher has multiple students. I have a paper form that is in
Word. The paper form has a table that has 15 blank rows for student
names and many boxes across for check marks. It's basically a large
grid. I've posted a picture because I'm sure I've confused many with
that description. http://trivalleyavcn.com/grid.jpg.

Basically I want to insert one teacher name and then list all of their
students underneath them in the blank boxes. When there are no more
students for that teacher, I want to page break and move on to the next
page.

I've tried the instructions from MS about creating a sorted mail merge
list, and it did work, but I don't think there's anyway to make it
break for rows in a table.
http://support.microsoft.com/?scid=http://www.support.microsoft.com/kb/294686/

So, is there anyway I can force an access report to send the data to
fill the word form? I've read some about bookmarks, but it looks like
those won't work in this situation. I'd like to avoid recreating the
grid in Access, as I can never make anything look the same as it does
in word.

Thank you very much for any ideas you have,

 

[Duane Hookom]

This looks like it could be fairly easy to create in Access. If you can't
figure this out, there is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
function would allow you to create all students in a single expression with
tabs and carriage returns.

 

[Peter R. Fletcher]

I agree with Duane. This form should be very easy to duplicate as an
Access Report, and is impossible to do as a simple Word merge. One
could do it _relatively_ easily by using Word Automation from VBA in
Access, but I consider myself to be good at Access Word Automation and
I would still follow the Access Report route in solving this problem.

Hello everyone,
I've been racking my brain trying to figure this out and have hit a
wall. Hopefully someone has an idea for this situation.

I have a query that gives me a list of teachers and their students.
Each teacher has multiple students. I have a paper form that is in
Word. The paper form has a table that has 15 blank rows for student
names and many boxes across for check marks. It's basically a large
grid. I've posted a picture because I'm sure I've confused many with
that description. http://trivalleyavcn.com/grid.jpg.

Basically I want to insert one teacher name and then list all of their
students underneath them in the blank boxes. When there are no more
students for that teacher, I want to page break and move on to the next
page.

I've tried the instructions from MS about creating a sorted mail merge
list, and it did work, but I don't think there's anyway to make it
break for rows in a table.
http://support.microsoft.com/?scid=http://www.support.microsoft.com/kb/294686/

So, is there anyway I can force an access report to send the data to
fill the word form? I've read some about bookmarks, but it looks like
those won't work in this situation. I'd like to avoid recreating the
grid in Access, as I can never make anything look the same as it does
in word.

Thank you very much for any ideas you have,

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher