M
Mark Jerde
Office 2003. Sorry if these are the wrong newsgroups or I missed finding
the answers in my Google and Office help searches. ;-) I _did_ look quite
awhile before posting...
I'm about 20% done with a research project. I'm assembling the data in a
multi-table Access DB because it's a lot easier to work with the data in
Access than Word. The Access forms and reports are exactly what is needed
for this phase of the project.
But one of the main *required* outputs of the project is a Word document.
In Access, the toolbar option "OfficeLinks | Publish It with Microsoft
Office Word" works nicely, but the resulting document requires lots of
formatting to apply the desired styles. Since I'm already well over 20
pages, and I expect to have to produce many iterations of the document as
work progresses, I don't want to apply the formatting manually.
Could someone provide links to building a Word document from Access data,
applying styles and formatting in VBA as the document is constructed? I
think it's just a matter of figuring out the objects needed, because I
created poster-size Excel 2000 worksheets from Access 2000 DBs a few years
ago. "I know what I want to do, but where in this tree is it?" <g>
Thanks in advance.
-- Mark
the answers in my Google and Office help searches. ;-) I _did_ look quite
awhile before posting...
I'm about 20% done with a research project. I'm assembling the data in a
multi-table Access DB because it's a lot easier to work with the data in
Access than Word. The Access forms and reports are exactly what is needed
for this phase of the project.
But one of the main *required* outputs of the project is a Word document.
In Access, the toolbar option "OfficeLinks | Publish It with Microsoft
Office Word" works nicely, but the resulting document requires lots of
formatting to apply the desired styles. Since I'm already well over 20
pages, and I expect to have to produce many iterations of the document as
work progresses, I don't want to apply the formatting manually.
Could someone provide links to building a Word document from Access data,
applying styles and formatting in VBA as the document is constructed? I
think it's just a matter of figuring out the objects needed, because I
created poster-size Excel 2000 worksheets from Access 2000 DBs a few years
ago. "I know what I want to do, but where in this tree is it?" <g>
Thanks in advance.
-- Mark