Insert Access Report into Word Doc
I have an MSAccess database and have generated some queries, which I have formatted nicely into reports. Now I want to generate a Word document, inserting the formatted report. I used bookmarks and the WordObj.ActiveDocument.TypeText command to insert several other fields. Can I use a bookmark to show where I want the report inserted, and if so, what command do I use? If not, is there another way to do this programmatically?
Re: Insert Access Report into Word Doc
You may be able to if you can Export the report as an OLE type that can be inserted into a Word doc. I'm not sure if Word understands what an Access report is.
Re: Insert Access Report into Word Doc
Moved to Office Development.
Re: Insert Access Report into Word Doc
I will look into exporting as an OLE... is there a better way to accomplish what I am trying to do?
It's basically a memorandum, with some different fields from different tables inserted (using bookmarks). That part works perfectly. But I also need to include a list of records, based on a specific query, and I'd like to be able to format the data so it looks nice. I don't care if its done in Access or Word or whatever. Any ideas?