Filling out a Word document "spencer nash" <Spencer.Nash[ at ]gmail.com> 06.09.2006 08:35:41 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%3A%2F%2Fwww.support.microsoft.com%2Fkb%2F294686%2F 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,

Re: Filling out a Word document "Duane Hookom" <DuaneAtNoSpanHookomDotNet> 06.09.2006 14:58:35 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. -- Duane Hookom MS Access MVP "spencer nash" <Spencer.Nash[ at ]gmail.com> wrote in message news:1157531741.248954.3590[ at ]i3g2000cwc.googlegroups.com... [Quoted Text] > 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%3A%2F%2Fwww.support.microsoft.com%2Fkb%2F294686%2F > > 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, >

Re: Filling out a Word document Peter R. Fletcher <seebelow[ at ]mydomain.com> 07.09.2006 08:31:50 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. On 6 Sep 2006 01:35:41 -0700, "spencer nash" <Spencer.Nash[ at ]gmail.com> wrote: [Quoted Text] >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%3A%2F%2Fwww.support.microsoft.com%2Fkb%2F294686%2F > >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