I was working on creating a one-to-many mailmerge in Word from an Access database and in the course of trying to do this ended up learning a method for doing not only simple one-to-many reports but potential much more complex ‘drill-down’ style queries for reports. This method can be done generically in any application that supports the provider MSDatShapes. I ended up using ASP in a webserver to output my results to an .rtf file but you should be able to do the same thing internally in Word. One problem I had with using Word for this is that my workgroup enviornment shares Normal.dot and this can be a pain when trying to work with a macros. In addition, I’ve a lot more experience using recordsets in ASP and enjoy the less ‘finicky’ development environment of ASP. However, the solution to this sort of thing should work fine in the VBA development enviornment.
The attached Word document goes thru the general method of invoking MSDataShapes, creating a MSDataShape SQL statement with generic example LOOPing code for paging thru the MSDataShape recordset objects.
